DBA Data[Home] [Help]

APPS.BEN_RT_PRFL_CACHE dependencies on HR_UTILITY

Line 482: hr_utility.set_location('No Person Groups found', 90);

478: --
479: when no_data_found then
480: --
481: p_inst_count := 0;
482: hr_utility.set_location('No Person Groups found', 90);
483: hr_utility.set_location('Leaving : ' || l_proc, 99);
484: --
485: end;
486: --

Line 483: hr_utility.set_location('Leaving : ' || l_proc, 99);

479: when no_data_found then
480: --
481: p_inst_count := 0;
482: hr_utility.set_location('No Person Groups found', 90);
483: hr_utility.set_location('Leaving : ' || l_proc, 99);
484: --
485: end;
486: --
487: /*procedure get_rt_prfl_cache

Line 568: hr_utility.set_location('No Person Groups found', 90);

564: --
565: when no_data_found then
566: --
567: p_inst_count := 0;
568: hr_utility.set_location('No Person Groups found', 90);
569: hr_utility.set_location('Leaving : ' || l_proc, 99);
570: --
571: end;
572: */

Line 569: hr_utility.set_location('Leaving : ' || l_proc, 99);

565: when no_data_found then
566: --
567: p_inst_count := 0;
568: hr_utility.set_location('No Person Groups found', 90);
569: hr_utility.set_location('Leaving : ' || l_proc, 99);
570: --
571: end;
572: */
573: --

Line 650: hr_utility.set_location('No Rules found', 90);

646: --
647: when no_data_found then
648: --
649: p_inst_count := 0;
650: hr_utility.set_location('No Rules found', 90);
651: hr_utility.set_location('Leaving : ' || l_proc, 99);
652: --
653: end;
654: --

Line 651: hr_utility.set_location('Leaving : ' || l_proc, 99);

647: when no_data_found then
648: --
649: p_inst_count := 0;
650: hr_utility.set_location('No Rules found', 90);
651: hr_utility.set_location('Leaving : ' || l_proc, 99);
652: --
653: end;
654: --
655: -- TOBACCO

Line 738: hr_utility.set_location('No Tobacco Data found', 90);

734: --
735: when no_data_found then
736: --
737: p_inst_count := 0;
738: hr_utility.set_location('No Tobacco Data found', 90);
739: hr_utility.set_location('Leaving : ' || l_proc, 99);
740: --
741: end;
742: --

Line 739: hr_utility.set_location('Leaving : ' || l_proc, 99);

735: when no_data_found then
736: --
737: p_inst_count := 0;
738: hr_utility.set_location('No Tobacco Data found', 90);
739: hr_utility.set_location('Leaving : ' || l_proc, 99);
740: --
741: end;
742: --
743: -- GENDER

Line 826: hr_utility.set_location('No Genders found', 90);

822: --
823: when no_data_found then
824: --
825: p_inst_count := 0;
826: hr_utility.set_location('No Genders found', 90);
827: hr_utility.set_location('Leaving : ' || l_proc, 99);
828: --
829: end;
830: --

Line 827: hr_utility.set_location('Leaving : ' || l_proc, 99);

823: when no_data_found then
824: --
825: p_inst_count := 0;
826: hr_utility.set_location('No Genders found', 90);
827: hr_utility.set_location('Leaving : ' || l_proc, 99);
828: --
829: end;
830: --
831: -- Disabled

Line 914: hr_utility.set_location('No Disabled Code found', 90);

910: --
911: when no_data_found then
912: --
913: p_inst_count := 0;
914: hr_utility.set_location('No Disabled Code found', 90);
915: hr_utility.set_location('Leaving : ' || l_proc, 99);
916: --
917: end;
918: --

Line 915: hr_utility.set_location('Leaving : ' || l_proc, 99);

911: when no_data_found then
912: --
913: p_inst_count := 0;
914: hr_utility.set_location('No Disabled Code found', 90);
915: hr_utility.set_location('Leaving : ' || l_proc, 99);
916: --
917: end;
918: --
919: -- BARGAINING UNIT

Line 1002: hr_utility.set_location('No Bargining found', 90);

998: --
999: when no_data_found then
1000: --
1001: p_inst_count := 0;
1002: hr_utility.set_location('No Bargining found', 90);
1003: hr_utility.set_location('Leaving : ' || l_proc, 99);
1004: --
1005: end;
1006: --

Line 1003: hr_utility.set_location('Leaving : ' || l_proc, 99);

999: when no_data_found then
1000: --
1001: p_inst_count := 0;
1002: hr_utility.set_location('No Bargining found', 90);
1003: hr_utility.set_location('Leaving : ' || l_proc, 99);
1004: --
1005: end;
1006: --
1007: -- BENEFITS GROUP

Line 1090: hr_utility.set_location('No data found', 90);

1086: --
1087: when no_data_found then
1088: --
1089: p_inst_count := 0;
1090: hr_utility.set_location('No data found', 90);
1091: hr_utility.set_location('Leaving : ' || l_proc, 99);
1092: --
1093: end;
1094: --

Line 1091: hr_utility.set_location('Leaving : ' || l_proc, 99);

1087: when no_data_found then
1088: --
1089: p_inst_count := 0;
1090: hr_utility.set_location('No data found', 90);
1091: hr_utility.set_location('Leaving : ' || l_proc, 99);
1092: --
1093: end;
1094: --
1095: -- EMPLOYEE STATUS

Line 1179: hr_utility.set_location('No Employee Status found', 90);

1175: --
1176: when no_data_found then
1177: --
1178: p_inst_count := 0;
1179: hr_utility.set_location('No Employee Status found', 90);
1180: hr_utility.set_location('Leaving : ' || l_proc, 99);
1181: --
1182: end;
1183: --

Line 1180: hr_utility.set_location('Leaving : ' || l_proc, 99);

1176: when no_data_found then
1177: --
1178: p_inst_count := 0;
1179: hr_utility.set_location('No Employee Status found', 90);
1180: hr_utility.set_location('Leaving : ' || l_proc, 99);
1181: --
1182: end;
1183: --
1184: -- FULL TIME PART TIME

Line 1396: hr_utility.set_location('No Grade found', 90);

1392: --
1393: when no_data_found then
1394: --
1395: p_inst_count := 0;
1396: hr_utility.set_location('No Grade found', 90);
1397: hr_utility.set_location('Leaving : ' || l_proc, 99);
1398: --
1399: end;
1400: --

Line 1397: hr_utility.set_location('Leaving : ' || l_proc, 99);

1393: when no_data_found then
1394: --
1395: p_inst_count := 0;
1396: hr_utility.set_location('No Grade found', 90);
1397: hr_utility.set_location('Leaving : ' || l_proc, 99);
1398: --
1399: end;
1400: --
1401: -- PERCENT FULL TIME

Line 1492: hr_utility.set_location('No Percent Full Time found', 90);

1488: --
1489: when no_data_found then
1490: --
1491: p_inst_count := 0;
1492: hr_utility.set_location('No Percent Full Time found', 90);
1493: hr_utility.set_location('Leaving : ' || l_proc, 99);
1494: --
1495: end;
1496: --

Line 1493: hr_utility.set_location('Leaving : ' || l_proc, 99);

1489: when no_data_found then
1490: --
1491: p_inst_count := 0;
1492: hr_utility.set_location('No Percent Full Time found', 90);
1493: hr_utility.set_location('Leaving : ' || l_proc, 99);
1494: --
1495: end;
1496: --
1497: -- HOURS WORKED

Line 1588: hr_utility.set_location('No Hours Worked found', 90);

1584: --
1585: when no_data_found then
1586: --
1587: p_inst_count := 0;
1588: hr_utility.set_location('No Hours Worked found', 90);
1589: hr_utility.set_location('Leaving : ' || l_proc, 99);
1590: --
1591: end;
1592: --

Line 1589: hr_utility.set_location('Leaving : ' || l_proc, 99);

1585: when no_data_found then
1586: --
1587: p_inst_count := 0;
1588: hr_utility.set_location('No Hours Worked found', 90);
1589: hr_utility.set_location('Leaving : ' || l_proc, 99);
1590: --
1591: end;
1592: --
1593: -- HOURS WORKED

Line 1690: hr_utility.set_location('No Period of Enrollment found', 90);

1686: --
1687: when no_data_found then
1688: --
1689: p_inst_count := 0;
1690: hr_utility.set_location('No Period of Enrollment found', 90);
1691: hr_utility.set_location('Leaving : ' || l_proc, 99);
1692: --
1693: end;
1694: --

Line 1691: hr_utility.set_location('Leaving : ' || l_proc, 99);

1687: when no_data_found then
1688: --
1689: p_inst_count := 0;
1690: hr_utility.set_location('No Period of Enrollment found', 90);
1691: hr_utility.set_location('Leaving : ' || l_proc, 99);
1692: --
1693: end;
1694: --
1695: -- LABOR UNION MEMBERSHIP

Line 1778: hr_utility.set_location('No Labor Union found', 90);

1774: --
1775: when no_data_found then
1776: --
1777: p_inst_count := 0;
1778: hr_utility.set_location('No Labor Union found', 90);
1779: hr_utility.set_location('Leaving : ' || l_proc, 99);
1780: --
1781: end;
1782: --

Line 1779: hr_utility.set_location('Leaving : ' || l_proc, 99);

1775: when no_data_found then
1776: --
1777: p_inst_count := 0;
1778: hr_utility.set_location('No Labor Union found', 90);
1779: hr_utility.set_location('Leaving : ' || l_proc, 99);
1780: --
1781: end;
1782: --
1783: -- LEGAL ENTITY

Line 1866: hr_utility.set_location('No Legal Entity found', 90);

1862: --
1863: when no_data_found then
1864: --
1865: p_inst_count := 0;
1866: hr_utility.set_location('No Legal Entity found', 90);
1867: hr_utility.set_location('Leaving : ' || l_proc, 99);
1868: --
1869: end;
1870: --

Line 1867: hr_utility.set_location('Leaving : ' || l_proc, 99);

1863: when no_data_found then
1864: --
1865: p_inst_count := 0;
1866: hr_utility.set_location('No Legal Entity found', 90);
1867: hr_utility.set_location('Leaving : ' || l_proc, 99);
1868: --
1869: end;
1870: --
1871: -- LEAVE OF ABSENCE

Line 2224: hr_utility.set_location('No Person Type found', 90);

2220: --
2221: when no_data_found then
2222: --
2223: p_inst_count := 0;
2224: hr_utility.set_location('No Person Type found', 90);
2225: hr_utility.set_location('Leaving : ' || l_proc, 99);
2226: --
2227: end;
2228: --

Line 2225: hr_utility.set_location('Leaving : ' || l_proc, 99);

2221: when no_data_found then
2222: --
2223: p_inst_count := 0;
2224: hr_utility.set_location('No Person Type found', 90);
2225: hr_utility.set_location('Leaving : ' || l_proc, 99);
2226: --
2227: end;
2228: --
2229: -- POSTAL ZIP RANGE

Line 2316: hr_utility.set_location('No Zip found', 90);

2312: --
2313: when no_data_found then
2314: --
2315: p_inst_count := 0;
2316: hr_utility.set_location('No Zip found', 90);
2317: hr_utility.set_location('Leaving : ' || l_proc, 99);
2318: --
2319: end;
2320: --

Line 2317: hr_utility.set_location('Leaving : ' || l_proc, 99);

2313: when no_data_found then
2314: --
2315: p_inst_count := 0;
2316: hr_utility.set_location('No Zip found', 90);
2317: hr_utility.set_location('Leaving : ' || l_proc, 99);
2318: --
2319: end;
2320: --
2321: -- PAYROLL

Line 2404: hr_utility.set_location('No Payroll found', 90);

2400: --
2401: when no_data_found then
2402: --
2403: p_inst_count := 0;
2404: hr_utility.set_location('No Payroll found', 90);
2405: hr_utility.set_location('Leaving : ' || l_proc, 99);
2406: --
2407: end;
2408: --

Line 2405: hr_utility.set_location('Leaving : ' || l_proc, 99);

2401: when no_data_found then
2402: --
2403: p_inst_count := 0;
2404: hr_utility.set_location('No Payroll found', 90);
2405: hr_utility.set_location('Leaving : ' || l_proc, 99);
2406: --
2407: end;
2408: --
2409: -- PAY BASIS

Line 2492: hr_utility.set_location('No Pay Basis found', 90);

2488: --
2489: when no_data_found then
2490: --
2491: p_inst_count := 0;
2492: hr_utility.set_location('No Pay Basis found', 90);
2493: hr_utility.set_location('Leaving : ' || l_proc, 99);
2494: --
2495: end;
2496: --

Line 2493: hr_utility.set_location('Leaving : ' || l_proc, 99);

2489: when no_data_found then
2490: --
2491: p_inst_count := 0;
2492: hr_utility.set_location('No Pay Basis found', 90);
2493: hr_utility.set_location('Leaving : ' || l_proc, 99);
2494: --
2495: end;
2496: --
2497: -- SCHEDULED HOURS

Line 2599: hr_utility.set_location('No Scheduled Hours found', 90);

2595: --
2596: when no_data_found then
2597: --
2598: p_inst_count := 0;
2599: hr_utility.set_location('No Scheduled Hours found', 90);
2600: hr_utility.set_location('Leaving : ' || l_proc, 99);
2601: --
2602: end;
2603: --

Line 2600: hr_utility.set_location('Leaving : ' || l_proc, 99);

2596: when no_data_found then
2597: --
2598: p_inst_count := 0;
2599: hr_utility.set_location('No Scheduled Hours found', 90);
2600: hr_utility.set_location('Leaving : ' || l_proc, 99);
2601: --
2602: end;
2603: --
2604: -- WORK LOCATION

Line 2687: hr_utility.set_location('No Work Location found', 90);

2683: --
2684: when no_data_found then
2685: --
2686: p_inst_count := 0;
2687: hr_utility.set_location('No Work Location found', 90);
2688: hr_utility.set_location('Leaving : ' || l_proc, 99);
2689: --
2690: end;
2691: --

Line 2688: hr_utility.set_location('Leaving : ' || l_proc, 99);

2684: when no_data_found then
2685: --
2686: p_inst_count := 0;
2687: hr_utility.set_location('No Work Location found', 90);
2688: hr_utility.set_location('Leaving : ' || l_proc, 99);
2689: --
2690: end;
2691: --
2692: -- SERVICE AREA

Line 2787: hr_utility.set_location('No Service Area found', 90);

2783: --
2784: when no_data_found then
2785: --
2786: p_inst_count := 0;
2787: hr_utility.set_location('No Service Area found', 90);
2788: hr_utility.set_location('Leaving : ' || l_proc, 99);
2789: --
2790: end;
2791: --

Line 2788: hr_utility.set_location('Leaving : ' || l_proc, 99);

2784: when no_data_found then
2785: --
2786: p_inst_count := 0;
2787: hr_utility.set_location('No Service Area found', 90);
2788: hr_utility.set_location('Leaving : ' || l_proc, 99);
2789: --
2790: end;
2791: --
2792: -- HOURLY OR SALARIED

Line 2875: hr_utility.set_location('No Hourly - Salaried found', 90);

2871: --
2872: when no_data_found then
2873: --
2874: p_inst_count := 0;
2875: hr_utility.set_location('No Hourly - Salaried found', 90);
2876: hr_utility.set_location('Leaving : ' || l_proc, 99);
2877: --
2878: end;
2879: --

Line 2876: hr_utility.set_location('Leaving : ' || l_proc, 99);

2872: when no_data_found then
2873: --
2874: p_inst_count := 0;
2875: hr_utility.set_location('No Hourly - Salaried found', 90);
2876: hr_utility.set_location('Leaving : ' || l_proc, 99);
2877: --
2878: end;
2879: --
2880: -- AGE

Line 3136: hr_utility.set_location('No Comp Lvl Code found', 90);

3132: --
3133: when no_data_found then
3134: --
3135: p_inst_count := 0;
3136: hr_utility.set_location('No Comp Lvl Code found', 90);
3137: hr_utility.set_location('Leaving : ' || l_proc, 99);
3138: --
3139: end;
3140: --

Line 3137: hr_utility.set_location('Leaving : ' || l_proc, 99);

3133: when no_data_found then
3134: --
3135: p_inst_count := 0;
3136: hr_utility.set_location('No Comp Lvl Code found', 90);
3137: hr_utility.set_location('Leaving : ' || l_proc, 99);
3138: --
3139: end;
3140: --
3141: -- LOS

Line 3399: hr_utility.set_location('No Length of Service found', 90);

3395: --
3396: when no_data_found then
3397: --
3398: p_inst_count := 0;
3399: hr_utility.set_location('No Length of Service found', 90);
3400: hr_utility.set_location('Leaving : ' || l_proc, 99);
3401: --
3402: end;
3403: */

Line 3400: hr_utility.set_location('Leaving : ' || l_proc, 99);

3396: when no_data_found then
3397: --
3398: p_inst_count := 0;
3399: hr_utility.set_location('No Length of Service found', 90);
3400: hr_utility.set_location('Leaving : ' || l_proc, 99);
3401: --
3402: end;
3403: */
3404: --

Line 3495: hr_utility.set_location('No Cmbn Age Los found', 90);

3491: --
3492: when no_data_found then
3493: --
3494: p_inst_count := 0;
3495: hr_utility.set_location('No Cmbn Age Los found', 90);
3496: hr_utility.set_location('Leaving : ' || l_proc, 99);
3497: --
3498: end;
3499: ------------------------------------------------------------------------

Line 3496: hr_utility.set_location('Leaving : ' || l_proc, 99);

3492: when no_data_found then
3493: --
3494: p_inst_count := 0;
3495: hr_utility.set_location('No Cmbn Age Los found', 90);
3496: hr_utility.set_location('Leaving : ' || l_proc, 99);
3497: --
3498: end;
3499: ------------------------------------------------------------------------
3500: -- TOTAL PARTICIPANTS

Line 3713: hr_utility.set_location('No data found - Coverage', 10);

3709: --
3710: when no_data_found then
3711: --
3712: p_inst_count := 0;
3713: hr_utility.set_location('No data found - Coverage', 10);
3714: hr_utility.set_location('Leaving : ' || l_proc, 99);
3715: --
3716: end;
3717:

Line 3714: hr_utility.set_location('Leaving : ' || l_proc, 99);

3710: when no_data_found then
3711: --
3712: p_inst_count := 0;
3713: hr_utility.set_location('No data found - Coverage', 10);
3714: hr_utility.set_location('Leaving : ' || l_proc, 99);
3715: --
3716: end;
3717:
3718:

Line 3803: hr_utility.set_location('No Job found', 90);

3799: --
3800: when no_data_found then
3801: --
3802: p_inst_count := 0;
3803: hr_utility.set_location('No Job found', 90);
3804: hr_utility.set_location('Leaving : ' || l_proc, 99);
3805: --
3806: end;
3807:

Line 3804: hr_utility.set_location('Leaving : ' || l_proc, 99);

3800: when no_data_found then
3801: --
3802: p_inst_count := 0;
3803: hr_utility.set_location('No Job found', 90);
3804: hr_utility.set_location('Leaving : ' || l_proc, 99);
3805: --
3806: end;
3807:
3808: ------------------------------------------------------------------------

Line 3890: hr_utility.set_location('No Opted for Medicare found', 90);

3886: --
3887: when no_data_found then
3888: --
3889: p_inst_count := 0;
3890: hr_utility.set_location('No Opted for Medicare found', 90);
3891: hr_utility.set_location('Leaving : ' || l_proc, 99);
3892: --
3893: end;
3894: ------------------------------------------------------------------------

Line 3891: hr_utility.set_location('Leaving : ' || l_proc, 99);

3887: when no_data_found then
3888: --
3889: p_inst_count := 0;
3890: hr_utility.set_location('No Opted for Medicare found', 90);
3891: hr_utility.set_location('Leaving : ' || l_proc, 99);
3892: --
3893: end;
3894: ------------------------------------------------------------------------
3895: -- Leaving Reason

Line 3978: hr_utility.set_location('No Leaving Reason found', 90);

3974: --
3975: when no_data_found then
3976: --
3977: p_inst_count := 0;
3978: hr_utility.set_location('No Leaving Reason found', 90);
3979: hr_utility.set_location('Leaving : ' || l_proc, 99);
3980: --
3981: end;
3982:

Line 3979: hr_utility.set_location('Leaving : ' || l_proc, 99);

3975: when no_data_found then
3976: --
3977: p_inst_count := 0;
3978: hr_utility.set_location('No Leaving Reason found', 90);
3979: hr_utility.set_location('Leaving : ' || l_proc, 99);
3980: --
3981: end;
3982:
3983: ------------------------------------------------------------------------

Line 4071: hr_utility.set_location('No Cobra Qualified Benificiary found', 90);

4067: --
4068: when no_data_found then
4069: --
4070: p_inst_count := 0;
4071: hr_utility.set_location('No Cobra Qualified Benificiary found', 90);
4072: hr_utility.set_location('Leaving : ' || l_proc, 99);
4073: --
4074: end;
4075:

Line 4072: hr_utility.set_location('Leaving : ' || l_proc, 99);

4068: when no_data_found then
4069: --
4070: p_inst_count := 0;
4071: hr_utility.set_location('No Cobra Qualified Benificiary found', 90);
4072: hr_utility.set_location('Leaving : ' || l_proc, 99);
4073: --
4074: end;
4075:
4076: ------------------------------------------------------------------------

Line 4164: hr_utility.set_location('No continuing participant profile found', 90);

4160: --
4161: when no_data_found then
4162: --
4163: p_inst_count := 0;
4164: hr_utility.set_location('No continuing participant profile found', 90);
4165: hr_utility.set_location('Leaving : ' || l_proc, 99);
4166: --
4167: end;
4168:

Line 4165: hr_utility.set_location('Leaving : ' || l_proc, 99);

4161: when no_data_found then
4162: --
4163: p_inst_count := 0;
4164: hr_utility.set_location('No continuing participant profile found', 90);
4165: hr_utility.set_location('Leaving : ' || l_proc, 99);
4166: --
4167: end;
4168:
4169:

Line 4254: hr_utility.set_location('No position found', 90);

4250: --
4251: when no_data_found then
4252: --
4253: p_inst_count := 0;
4254: hr_utility.set_location('No position found', 90);
4255: hr_utility.set_location('Leaving : ' || l_proc, 99);
4256: --
4257: end;
4258:

Line 4255: hr_utility.set_location('Leaving : ' || l_proc, 99);

4251: when no_data_found then
4252: --
4253: p_inst_count := 0;
4254: hr_utility.set_location('No position found', 90);
4255: hr_utility.set_location('Leaving : ' || l_proc, 99);
4256: --
4257: end;
4258:
4259:

Line 4347: hr_utility.set_location('No compentency found', 90);

4343: --
4344: when no_data_found then
4345: --
4346: p_inst_count := 0;
4347: hr_utility.set_location('No compentency found', 90);
4348: hr_utility.set_location('Leaving : ' || l_proc, 99);
4349: --
4350: end;
4351:

Line 4348: hr_utility.set_location('Leaving : ' || l_proc, 99);

4344: when no_data_found then
4345: --
4346: p_inst_count := 0;
4347: hr_utility.set_location('No compentency found', 90);
4348: hr_utility.set_location('Leaving : ' || l_proc, 99);
4349: --
4350: end;
4351:
4352:

Line 4440: hr_utility.set_location('No qualification title found', 90);

4436: --
4437: when no_data_found then
4438: --
4439: p_inst_count := 0;
4440: hr_utility.set_location('No qualification title found', 90);
4441: hr_utility.set_location('Leaving : ' || l_proc, 99);
4442: --
4443: end;
4444:

Line 4441: hr_utility.set_location('Leaving : ' || l_proc, 99);

4437: when no_data_found then
4438: --
4439: p_inst_count := 0;
4440: hr_utility.set_location('No qualification title found', 90);
4441: hr_utility.set_location('Leaving : ' || l_proc, 99);
4442: --
4443: end;
4444:
4445:

Line 4534: hr_utility.set_location('Covered by Other Plan found', 90);

4530: --
4531: when no_data_found then
4532: --
4533: p_inst_count := 0;
4534: hr_utility.set_location('Covered by Other Plan found', 90);
4535: hr_utility.set_location('Leaving : ' || l_proc, 99);
4536: --
4537: end ;
4538: ------------------------------------------------------------------------

Line 4535: hr_utility.set_location('Leaving : ' || l_proc, 99);

4531: when no_data_found then
4532: --
4533: p_inst_count := 0;
4534: hr_utility.set_location('Covered by Other Plan found', 90);
4535: hr_utility.set_location('Leaving : ' || l_proc, 99);
4536: --
4537: end ;
4538: ------------------------------------------------------------------------
4539: -- DCP Covered by Other Plan in Program

Line 4625: hr_utility.set_location('Covered by Other Plan in Program', 90);

4621: --
4622: when no_data_found then
4623: --
4624: p_inst_count := 0;
4625: hr_utility.set_location('Covered by Other Plan in Program', 90);
4626: hr_utility.set_location('Leaving : ' || l_proc, 99);
4627: --
4628: end ;
4629: ------------------------------------------------------------------------

Line 4626: hr_utility.set_location('Leaving : ' || l_proc, 99);

4622: when no_data_found then
4623: --
4624: p_inst_count := 0;
4625: hr_utility.set_location('Covered by Other Plan in Program', 90);
4626: hr_utility.set_location('Leaving : ' || l_proc, 99);
4627: --
4628: end ;
4629: ------------------------------------------------------------------------
4630: -- DCO Covered by Other Plan Type in Program

Line 4720: hr_utility.set_location('Covered by Other Plan Type in Program', 90);

4716: --
4717: when no_data_found then
4718: --
4719: p_inst_count := 0;
4720: hr_utility.set_location('Covered by Other Plan Type in Program', 90);
4721: hr_utility.set_location('Leaving : ' || l_proc, 99);
4722: --
4723: end ;
4724: --

Line 4721: hr_utility.set_location('Leaving : ' || l_proc, 99);

4717: when no_data_found then
4718: --
4719: p_inst_count := 0;
4720: hr_utility.set_location('Covered by Other Plan Type in Program', 90);
4721: hr_utility.set_location('Leaving : ' || l_proc, 99);
4722: --
4723: end ;
4724: --
4725: ------------------------------------------------------------------------

Line 4815: hr_utility.set_location('Covered by Other Program', 90);

4811: --
4812: when no_data_found then
4813: --
4814: p_inst_count := 0;
4815: hr_utility.set_location('Covered by Other Program', 90);
4816: hr_utility.set_location('Leaving : ' || l_proc, 99);
4817: --
4818: end ;
4819: --

Line 4816: hr_utility.set_location('Leaving : ' || l_proc, 99);

4812: when no_data_found then
4813: --
4814: p_inst_count := 0;
4815: hr_utility.set_location('Covered by Other Program', 90);
4816: hr_utility.set_location('Leaving : ' || l_proc, 99);
4817: --
4818: end ;
4819: --
4820: ------------------------------------------------------------------------

Line 4906: hr_utility.set_location('Eligible for Another Plan', 90);

4902: --
4903: when no_data_found then
4904: --
4905: p_inst_count := 0;
4906: hr_utility.set_location('Eligible for Another Plan', 90);
4907: hr_utility.set_location('Leaving : ' || l_proc, 99);
4908: --
4909: end ;
4910: --

Line 4907: hr_utility.set_location('Leaving : ' || l_proc, 99);

4903: when no_data_found then
4904: --
4905: p_inst_count := 0;
4906: hr_utility.set_location('Eligible for Another Plan', 90);
4907: hr_utility.set_location('Leaving : ' || l_proc, 99);
4908: --
4909: end ;
4910: --
4911: ------------------------------------------------------------------------

Line 5000: hr_utility.set_location('Eligible for Another Plan Type in Program', 90);

4996: --
4997: when no_data_found then
4998: --
4999: p_inst_count := 0;
5000: hr_utility.set_location('Eligible for Another Plan Type in Program', 90);
5001: hr_utility.set_location('Leaving : ' || l_proc, 99);
5002: --
5003: end ;
5004: --

Line 5001: hr_utility.set_location('Leaving : ' || l_proc, 99);

4997: when no_data_found then
4998: --
4999: p_inst_count := 0;
5000: hr_utility.set_location('Eligible for Another Plan Type in Program', 90);
5001: hr_utility.set_location('Leaving : ' || l_proc, 99);
5002: --
5003: end ;
5004: --
5005: ------------------------------------------------------------------------

Line 5093: hr_utility.set_location('Enrolled Another Plan', 90);

5089: --
5090: when no_data_found then
5091: --
5092: p_inst_count := 0;
5093: hr_utility.set_location('Enrolled Another Plan', 90);
5094: hr_utility.set_location('Leaving : ' || l_proc, 99);
5095: --
5096: end ;
5097: --

Line 5094: hr_utility.set_location('Leaving : ' || l_proc, 99);

5090: when no_data_found then
5091: --
5092: p_inst_count := 0;
5093: hr_utility.set_location('Enrolled Another Plan', 90);
5094: hr_utility.set_location('Leaving : ' || l_proc, 99);
5095: --
5096: end ;
5097: --
5098: ------------------------------------------------------------------------

Line 5186: hr_utility.set_location('Enrolled Another Option in Plan', 90);

5182: --
5183: when no_data_found then
5184: --
5185: p_inst_count := 0;
5186: hr_utility.set_location('Enrolled Another Option in Plan', 90);
5187: hr_utility.set_location('Leaving : ' || l_proc, 99);
5188: --
5189: end ;
5190: --

Line 5187: hr_utility.set_location('Leaving : ' || l_proc, 99);

5183: when no_data_found then
5184: --
5185: p_inst_count := 0;
5186: hr_utility.set_location('Enrolled Another Option in Plan', 90);
5187: hr_utility.set_location('Leaving : ' || l_proc, 99);
5188: --
5189: end ;
5190: --
5191: ------------------------------------------------------------------------

Line 5279: hr_utility.set_location('Enrolled Another Plan in Program', 90);

5275: --
5276: when no_data_found then
5277: --
5278: p_inst_count := 0;
5279: hr_utility.set_location('Enrolled Another Plan in Program', 90);
5280: hr_utility.set_location('Leaving : ' || l_proc, 99);
5281: --
5282: end ;
5283: --

Line 5280: hr_utility.set_location('Leaving : ' || l_proc, 99);

5276: when no_data_found then
5277: --
5278: p_inst_count := 0;
5279: hr_utility.set_location('Enrolled Another Plan in Program', 90);
5280: hr_utility.set_location('Leaving : ' || l_proc, 99);
5281: --
5282: end ;
5283: --
5284: ------------------------------------------------------------------------

Line 5375: hr_utility.set_location('Enrolled Another Plan Type in Program', 90);

5371: --
5372: when no_data_found then
5373: --
5374: p_inst_count := 0;
5375: hr_utility.set_location('Enrolled Another Plan Type in Program', 90);
5376: hr_utility.set_location('Leaving : ' || l_proc, 99);
5377: --
5378: end ;
5379: --

Line 5376: hr_utility.set_location('Leaving : ' || l_proc, 99);

5372: when no_data_found then
5373: --
5374: p_inst_count := 0;
5375: hr_utility.set_location('Enrolled Another Plan Type in Program', 90);
5376: hr_utility.set_location('Leaving : ' || l_proc, 99);
5377: --
5378: end ;
5379: --
5380: ------------------------------------------------------------------------

Line 5469: hr_utility.set_location('Enrolled Another Program', 90);

5465: --
5466: when no_data_found then
5467: --
5468: p_inst_count := 0;
5469: hr_utility.set_location('Enrolled Another Program', 90);
5470: hr_utility.set_location('Leaving : ' || l_proc, 99);
5471: --
5472: end ;
5473:

Line 5470: hr_utility.set_location('Leaving : ' || l_proc, 99);

5466: when no_data_found then
5467: --
5468: p_inst_count := 0;
5469: hr_utility.set_location('Enrolled Another Program', 90);
5470: hr_utility.set_location('Leaving : ' || l_proc, 99);
5471: --
5472: end ;
5473:
5474: ------------------------------------------------------------------------

Line 5561: hr_utility.set_location('Dependent covered in other plan type in program', 90);

5557: --
5558: when no_data_found then
5559: --
5560: p_inst_count := 0;
5561: hr_utility.set_location('Dependent covered in other plan type in program', 90);
5562: hr_utility.set_location('Leaving : ' || l_proc, 99);
5563: --
5564: end ;
5565: ------------------------------------------------------------------------

Line 5562: hr_utility.set_location('Leaving : ' || l_proc, 99);

5558: when no_data_found then
5559: --
5560: p_inst_count := 0;
5561: hr_utility.set_location('Dependent covered in other plan type in program', 90);
5562: hr_utility.set_location('Leaving : ' || l_proc, 99);
5563: --
5564: end ;
5565: ------------------------------------------------------------------------
5566: -- NOC No Other Coverage

Line 5648: hr_utility.set_location('No Other Coverage', 90);

5644: --
5645: when no_data_found then
5646: --
5647: p_inst_count := 0;
5648: hr_utility.set_location('No Other Coverage', 90);
5649: hr_utility.set_location('Leaving : ' || l_proc, 99);
5650: --
5651: end ;
5652:

Line 5649: hr_utility.set_location('Leaving : ' || l_proc, 99);

5645: when no_data_found then
5646: --
5647: p_inst_count := 0;
5648: hr_utility.set_location('No Other Coverage', 90);
5649: hr_utility.set_location('Leaving : ' || l_proc, 99);
5650: --
5651: end ;
5652:
5653: ------------------------------------------------------------------------

Line 5737: hr_utility.set_location('No Quartile in Grade found', 90);

5733: --
5734: when no_data_found then
5735: --
5736: p_inst_count := 0;
5737: hr_utility.set_location('No Quartile in Grade found', 90);
5738: hr_utility.set_location('Leaving : ' || l_proc, 99);
5739: --
5740: end;
5741:

Line 5738: hr_utility.set_location('Leaving : ' || l_proc, 99);

5734: when no_data_found then
5735: --
5736: p_inst_count := 0;
5737: hr_utility.set_location('No Quartile in Grade found', 90);
5738: hr_utility.set_location('Leaving : ' || l_proc, 99);
5739: --
5740: end;
5741:
5742: ------------------------------------------------------------------------

Line 5829: hr_utility.set_location('No performance rating found', 90);

5825: --
5826: when no_data_found then
5827: --
5828: p_inst_count := 0;
5829: hr_utility.set_location('No performance rating found', 90);
5830: hr_utility.set_location('Leaving : ' || l_proc, 99);
5831: --
5832: end;
5833:

Line 5830: hr_utility.set_location('Leaving : ' || l_proc, 99);

5826: when no_data_found then
5827: --
5828: p_inst_count := 0;
5829: hr_utility.set_location('No performance rating found', 90);
5830: hr_utility.set_location('Leaving : ' || l_proc, 99);
5831: --
5832: end;
5833:
5834: ------------------------------------------------------------------------