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.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on HR_UTILITY

Line 585: hr_utility.set_location('Entering: '||l_proc,10);

581: -- This module creates choices from which we want to hang flex credit rates
582: -- We hang flex credit rates of chcs with comp_lvls of:
583: -- PGM, PTIP, PLIP, OIPLIP, CPTIP (Combo ptip), CPLIP, CPTIPOPT (Combo ptip/opt)
584: -- Regular rates should not hang off these choices.
585: hr_utility.set_location('Entering: '||l_proc,10);
586: -- clear out table of combination records that were written.
587: l_wrote_cmbn.delete;
588: if p_effective_date is null then
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

Line 662: hr_utility.set_location('Write Pgm Lvl Flx Cr Distr Rec ',20);

658: p_effective_date => p_effective_date);
659: else
660: -- Write Program Level Flex Credit Distribution Record
661: --
662: hr_utility.set_location('Write Pgm Lvl Flx Cr Distr Rec ',20);
663: ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
664: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
665: p_elctbl_flag => 'N',
666: p_comp_lvl_cd => 'PGM',

Line 678: hr_utility.set_location('Dn BEPECAPI_CRE 1: '||l_proc,10);

674: p_request_id => fnd_global.conc_request_id,
675: p_program_update_date => sysdate,
676: p_object_version_number => l_object_version_number,
677: p_effective_date => p_effective_date);
678: hr_utility.set_location('Dn BEPECAPI_CRE 1: '||l_proc,10);
679: end if;
680: --
681: end if;
682: close c_bpp1;

Line 687: hr_utility.set_location('Dn c_epe_pgm ',10);

683: close c_abr1;
684: end if ;
685: end loop;
686:
687: hr_utility.set_location('Dn c_epe_pgm ',10);
688:
689: -- There is no reason to continue if there are no flex program choices.
690: if l_found_pgm = 'Y' then
691: ---------------------------------------------------------------------

Line 734: hr_utility.set_location('PLIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);

730: open c_bpp2;
731: fetch c_bpp2 into l_bnft_prvdr_pool_id ;
732: close c_bpp2;
733: --
734: hr_utility.set_location('PLIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);
735: --
736: -- Combination PLIP level
737: --
738: if l_bnft_prvdr_pool_id is null then

Line 748: hr_utility.set_location('PLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);

744: close c_bpp5;
745: --
746: end if;
747: --
748: hr_utility.set_location('PLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);
749: -- Now Find the pool at PTIP level
750: --
751: if l_bnft_prvdr_pool_id is null then
752: --

Line 759: hr_utility.set_location('PLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);

755: close c_bpp3;
756: --
757: end if;
758: --
759: hr_utility.set_location('PLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);
760: --
761: -- Combination PTIP level
762: --
763: if l_bnft_prvdr_pool_id is null then

Line 773: hr_utility.set_location('PLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);

769: close c_bpp4;
770: --
771: end if;
772: --
773: hr_utility.set_location('PLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);
774: -- Now Find the pool at Program level
775: --
776: if l_bnft_prvdr_pool_id is null then
777: --

Line 814: hr_utility.set_location('Write Plip Lvl Flx Cr Distr Rec '||

810: p_effective_date => p_effective_date);
811: else
812: -- Write Plip Level Flex Credit Distribution Record
813: --
814: hr_utility.set_location('Write Plip Lvl Flx Cr Distr Rec '||
815: to_char(l_epe_plip.plip_id),30);
816: ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
817: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
818: p_elctbl_flag => 'N',

Line 837: hr_utility.set_location('Dn BEPECAPI_CRE 2: ',10);

833: p_request_id => fnd_global.conc_request_id,
834: p_program_update_date => sysdate,
835: p_object_version_number => l_object_version_number,
836: p_effective_date => p_effective_date);
837: hr_utility.set_location('Dn BEPECAPI_CRE 2: ',10);
838: end if;
839: --
840: end if;
841: --

Line 846: hr_utility.set_location(' Dn PLIP ',10);

842: end if; -- c_abr2 found
843: close c_abr2;
844: end if; -- Override loop
845: end loop;
846: hr_utility.set_location(' Dn PLIP ',10);
847: ---------------------------------------------------------------------
848: -- Process COMBO PLIP Level Flex Credits
849: ---------------------------------------------------------------------
850: l_num_cmbn:=0;

Line 860: hr_utility.set_location('l_plip_id '||to_char(l_plip_id),10);

856: l_ptip_id := l_epe_plip.ptip_id;
857: l_cmbn_plip_id := null;
858: l_bnft_prvdr_pool_id := null ;
859: --
860: hr_utility.set_location('l_plip_id '||to_char(l_plip_id),10);
861: --
862: if l_pgm_id <> l_epe_plip.pgm_id then
863: open yr_perd_for_pgm (l_epe_plip.pgm_id);
864: fetch yr_perd_for_pgm into l_yr_perd_id;

Line 882: hr_utility.set_location('Cmbn PLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);

878: open c_bpp5;
879: fetch c_bpp5 into l_bnft_prvdr_pool_id, l_dummy_id ;
880: close c_bpp5;
881: --
882: hr_utility.set_location('Cmbn PLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);
883: -- Now Find the pool at PTIP level
884: --
885: if l_bnft_prvdr_pool_id is null then
886: --

Line 893: hr_utility.set_location('Cmbn PLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);

889: close c_bpp3;
890: --
891: end if;
892: --
893: hr_utility.set_location('Cmbn PLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);
894: --
895: -- Combination PTIP level
896: --
897: if l_bnft_prvdr_pool_id is null then

Line 907: hr_utility.set_location('Cmbn PLIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);

903: close c_bpp4;
904: --
905: end if;
906: --
907: hr_utility.set_location('Cmbn PLIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);
908: -- Now Find the pool at Program level
909: --
910: if l_bnft_prvdr_pool_id is null then
911: --

Line 918: hr_utility.set_location('Cmbn PLIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);

914: close c_bpp1;
915: --
916: end if;
917: --
918: hr_utility.set_location('Cmbn PLIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);
919: if l_bnft_prvdr_pool_id is not null then
920: --
921: -- Write Cmbn Plip Level Flex Credit Distribution Record
922: --

Line 927: hr_utility.set_location('loop cmbns plips written '||

923: -- save cmbn id so we only write it once.
924: l_write_this_one := 'Y';
925: if l_wrote_cmbn.first is not null then
926: for j in l_wrote_cmbn.first..l_wrote_cmbn.last loop
927: hr_utility.set_location('loop cmbns plips written '||
928: to_char(l_wrote_cmbn(j)),30);
929: if l_wrote_cmbn(j) = l_cmbn_plip_id then
930: l_write_this_one := 'N';
931: end if;

Line 936: hr_utility.set_location('Write Cmbn Plip Lvl Flx Cr Distr Rec '||

932: end loop;
933: end if;
934:
935: if l_write_this_one = 'Y' then
936: hr_utility.set_location('Write Cmbn Plip Lvl Flx Cr Distr Rec '||
937: to_char(l_cmbn_plip_id),30);
938: --Override Changes
939: --
940: l_create_override := 'N' ;

Line 1003: hr_utility.set_location('Dn BEPECAPI_CRE 5: ',10);

999: p_request_id => fnd_global.conc_request_id,
1000: p_program_update_date => sysdate,
1001: p_object_version_number => l_object_version_number,
1002: p_effective_date => p_effective_date);
1003: hr_utility.set_location('Dn BEPECAPI_CRE 5: ',10);
1004: end if;
1005: --
1006: end if; -- Override
1007: end if;

Line 1012: hr_utility.set_location('Dn c_epe_plip ',10);

1008: end if;
1009: end if;
1010: close c_abr5;
1011: end loop;
1012: hr_utility.set_location('Dn c_epe_plip ',10);
1013: -- clear out table of combination records that were written.
1014: ---------------------------------------------------------------------
1015: -- Process PTIP Level Flex Credits
1016: ---------------------------------------------------------------------

Line 1021: --hr_utility.set_location('pgm_id'||to_char(l_epe_ptip.pgm_id)||

1017: for l_epe_ptip in c_epe_ptip loop
1018: l_ptip_id := l_epe_ptip.ptip_id;
1019: l_bnft_prvdr_pool_id := null;
1020: l_cmbn_ptip_id := null ;
1021: --hr_utility.set_location('pgm_id'||to_char(l_epe_ptip.pgm_id)||
1022: -- ' ptip_id'||to_char(l_epe_ptip.ptip_id),10);
1023: --hr_utility.set_location(' ptip_ordr_num'||to_char(l_epe_ptip.ptip_ordr_num)||
1024: -- ' pl_typ_id'||to_char(l_epe_ptip.pl_typ_id),10);
1025: --

Line 1023: --hr_utility.set_location(' ptip_ordr_num'||to_char(l_epe_ptip.ptip_ordr_num)||

1019: l_bnft_prvdr_pool_id := null;
1020: l_cmbn_ptip_id := null ;
1021: --hr_utility.set_location('pgm_id'||to_char(l_epe_ptip.pgm_id)||
1022: -- ' ptip_id'||to_char(l_epe_ptip.ptip_id),10);
1023: --hr_utility.set_location(' ptip_ordr_num'||to_char(l_epe_ptip.ptip_ordr_num)||
1024: -- ' pl_typ_id'||to_char(l_epe_ptip.pl_typ_id),10);
1025: --
1026: --Override Changes
1027: --

Line 1056: hr_utility.set_location('PTIP abr7 found',20);

1052: -- OIPLIP or higher level.A
1053: --
1054: if c_abr3%found then
1055: --
1056: hr_utility.set_location('PTIP abr7 found',20);
1057: -- Now Find the pool at PTIP level
1058: --
1059: --
1060: open c_bpp3;

Line 1064: hr_utility.set_location('PTIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);

1060: open c_bpp3;
1061: fetch c_bpp3 into l_bnft_prvdr_pool_id ;
1062: close c_bpp3;
1063: --
1064: hr_utility.set_location('PTIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);
1065: --
1066: -- Combination PTIP level
1067: --
1068: if l_bnft_prvdr_pool_id is null then

Line 1078: hr_utility.set_location('PTIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);

1074: close c_bpp4;
1075: --
1076: end if;
1077: --
1078: hr_utility.set_location('PTIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);
1079: -- Now Find the pool at Program level
1080: --
1081: if l_bnft_prvdr_pool_id is null then
1082: --

Line 1119: hr_utility.set_location('Write Ptip Lvl Flx Cr Distr Rec '||

1115: p_effective_date => p_effective_date);
1116: else
1117: -- Write Ptip Level Flex Credit Distribution Record
1118: --
1119: hr_utility.set_location('Write Ptip Lvl Flx Cr Distr Rec '||
1120: to_char(l_epe_ptip.ptip_id),40);
1121: ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
1122: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1123: p_elctbl_flag => 'N',

Line 1139: hr_utility.set_location('Dn BEPECAPI_CRE 3: ',10);

1135: p_request_id => fnd_global.conc_request_id,
1136: p_program_update_date => sysdate,
1137: p_object_version_number => l_object_version_number,
1138: p_effective_date => p_effective_date);
1139: hr_utility.set_location('Dn BEPECAPI_CRE 3: ',10);
1140: --
1141: end if;
1142: --
1143: end if;

Line 1196: hr_utility.set_location('PTIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);

1192: open c_bpp4;
1193: fetch c_bpp4 into l_bnft_prvdr_pool_id, l_dummy_id ;
1194: close c_bpp4;
1195: --
1196: hr_utility.set_location('PTIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);
1197: -- Now Find the pool at Program level
1198: --
1199: if l_bnft_prvdr_pool_id is null then
1200: --

Line 1217: hr_utility.set_location('loop cmbns ptips written '||

1213: -- save cmbn id so we only write it once.
1214: l_write_this_one := 'Y';
1215: if l_wrote_cmbn.first is not null then
1216: for j in l_wrote_cmbn.first..l_wrote_cmbn.last loop
1217: hr_utility.set_location('loop cmbns ptips written '||
1218: to_char(l_wrote_cmbn(j)),30);
1219: if l_wrote_cmbn(j) = l_cmbn_ptip_id then
1220: l_write_this_one := 'N';
1221: end if;

Line 1226: hr_utility.set_location('Write Cmbn Ptip Lvl Flx Cr Distr Rec '||

1222: end loop;
1223: end if;
1224:
1225: if l_write_this_one = 'Y' then
1226: hr_utility.set_location('Write Cmbn Ptip Lvl Flx Cr Distr Rec '||
1227: to_char(l_cmbn_ptip_id),40);
1228: l_wrote_cmbn(l_num_cmbn) := l_cmbn_ptip_id;
1229: l_num_cmbn := l_num_cmbn+1;
1230: --

Line 1275: hr_utility.set_location('Dn BEPECAPI_CRE 4: ',10);

1271: p_request_id => fnd_global.conc_request_id,
1272: p_program_update_date => sysdate,
1273: p_object_version_number => l_object_version_number,
1274: p_effective_date => p_effective_date);
1275: hr_utility.set_location('Dn BEPECAPI_CRE 4: ',10);
1276: end if;
1277: --
1278: end if;
1279: end if;

Line 1292: hr_utility.set_location('Start EPE_OIPL loop ',10);

1288: l_wrote_cmbn.delete;
1289: ---------------------------------------------------------------------
1290: -- Process OIPLIP Level Flex Credits
1291: ---------------------------------------------------------------------
1292: hr_utility.set_location('Start EPE_OIPL loop ',10);
1293: for l_epe_oipl in c_epe_oipl loop
1294: l_oipl_id := l_epe_oipl.oipl_id;
1295: l_ptip_id := l_epe_oipl.ptip_id;
1296: l_oiplip_id := l_epe_oipl.oiplip_id;

Line 1331: hr_utility.set_location('OIPLIP pgm_id'||to_char(l_pgm_id)||

1327: --
1328: -- save the pgm id for the next records compare.
1329: l_pgm_id := l_epe_oipl.pgm_id;
1330: --
1331: hr_utility.set_location('OIPLIP pgm_id'||to_char(l_pgm_id)||
1332: ' l_oiplip_id'||to_char(l_oiplip_id)||' l_ptip_id'||to_char(l_ptip_id),10);
1333: --
1334: open c_abr7;
1335: fetch c_abr7 into l_abr7;

Line 1342: hr_utility.set_location('OIPLIP abr7 found',20);

1338: -- OIPLIP or higher level.A
1339: --
1340: if c_abr7%found then
1341: --
1342: hr_utility.set_location('OIPLIP abr7 found',20);
1343: -- Process OIPLIP
1344: open c_bpp7;
1345: fetch c_bpp7 into l_bnft_prvdr_pool_id; -- get required pool id.
1346: close c_bpp7;

Line 1349: hr_utility.set_location('OIPLIP Dn c_bpp7 '||l_bnft_prvdr_pool_id,20);

1345: fetch c_bpp7 into l_bnft_prvdr_pool_id; -- get required pool id.
1346: close c_bpp7;
1347: --
1348: -- Now Find the pool at Combination optip level
1349: hr_utility.set_location('OIPLIP Dn c_bpp7 '||l_bnft_prvdr_pool_id,20);
1350: --
1351: if l_bnft_prvdr_pool_id is null then
1352: --
1353: -- Look for the Benefit pool at Combination OPTIP level

Line 1360: hr_utility.set_location('OIPLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);

1356: fetch c_bpp6 into l_bnft_prvdr_pool_id, l_dummy_id ;
1357: close c_bpp6;
1358: --
1359: end if;
1360: hr_utility.set_location('OIPLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);
1361: --
1362: -- Now Find the pool at PLIP level
1363: --
1364: if l_bnft_prvdr_pool_id is null then

Line 1372: hr_utility.set_location('OIPLIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);

1368: close c_bpp2;
1369: --
1370: end if;
1371: --
1372: hr_utility.set_location('OIPLIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);
1373: --
1374: -- Combination PLIP level
1375: --
1376: if l_bnft_prvdr_pool_id is null then

Line 1386: hr_utility.set_location('OIPLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);

1382: close c_bpp5;
1383: --
1384: end if;
1385: --
1386: hr_utility.set_location('OIPLIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);
1387: -- Now Find the pool at PTIP level
1388: --
1389: if l_bnft_prvdr_pool_id is null then
1390: --

Line 1397: hr_utility.set_location('OIPLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);

1393: close c_bpp3;
1394: --
1395: end if;
1396: --
1397: hr_utility.set_location('OIPLIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);
1398: --
1399: -- Combination PTIP level
1400: --
1401: if l_bnft_prvdr_pool_id is null then

Line 1411: hr_utility.set_location('OIPLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);

1407: close c_bpp4;
1408: --
1409: end if;
1410: --
1411: hr_utility.set_location('OIPLIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);
1412: -- Now Find the pool at Program level
1413: --
1414: if l_bnft_prvdr_pool_id is null then
1415: --

Line 1422: hr_utility.set_location('OIPLIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);

1418: close c_bpp1;
1419: --
1420: end if;
1421: --
1422: hr_utility.set_location('OIPLIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);
1423: --
1424: if l_bnft_prvdr_pool_id is not null then
1425: --
1426: if p_mode in ('U','R') then

Line 1452: hr_utility.set_location('BP fount at bpid '||l_bnft_prvdr_pool_id ,30);

1448: p_yr_perd_id => l_yr_perd_id,
1449: p_business_group_id => p_business_group_id,
1450: p_effective_date => p_effective_date);
1451: else
1452: hr_utility.set_location('BP fount at bpid '||l_bnft_prvdr_pool_id ,30);
1453: ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
1454: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1455: p_elctbl_flag => 'N',
1456: p_comp_lvl_cd => 'OIPLIP',

Line 1491: hr_utility.set_location('Start EPE_COPTIP loop ',10);

1487: end loop;
1488: ---------------------------------------------------------------------
1489: -- Process Combo PTIP Option Level Flex Credits
1490: ---------------------------------------------------------------------
1491: hr_utility.set_location('Start EPE_COPTIP loop ',10);
1492: -- clear out table of combination records that were written.
1493: l_num_cmbn:=0;
1494: l_wrote_cmbn.delete;
1495: for l_epe_oipl in c_epe_oipl loop

Line 1508: hr_utility.set_location('OIPLIP pgm_id'||to_char(l_pgm_id)||

1504: l_bnft_prvdr_pool_id := null;
1505: l_cmbn_plip_id := null;
1506: l_cmbn_ptip_id := null ;
1507: --
1508: hr_utility.set_location('OIPLIP pgm_id'||to_char(l_pgm_id)||
1509: ' l_oiplip_id'||to_char(l_oiplip_id)||' l_ptip_id'||to_char(l_ptip_id),10);
1510: --
1511: if l_pgm_id <> l_epe_oipl.pgm_id then
1512: open yr_perd_for_pgm (l_epe_oipl.pgm_id);

Line 1525: hr_utility.set_location('COPTIP found c_abr6 cmbnptipoptid '||l_cmbn_ptip_opt_id,10);

1521: --
1522: if c_abr6%found then
1523: --
1524: l_cmbn_ptip_opt_id := l_abr6.cmbn_ptip_opt_id ;
1525: hr_utility.set_location('COPTIP found c_abr6 cmbnptipoptid '||l_cmbn_ptip_opt_id,10);
1526: --
1527: --
1528: --Override Changes
1529: --

Line 1552: hr_utility.set_location('COPTIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);

1548: open c_bpp6;
1549: fetch c_bpp6 into l_bnft_prvdr_pool_id, l_dummy_id ;
1550: close c_bpp6;
1551: --
1552: hr_utility.set_location('COPTIP Dn c_bpp6 '||l_bnft_prvdr_pool_id,20);
1553: -- Now Find the pool at PLIP level
1554: --
1555: if l_bnft_prvdr_pool_id is null then
1556: --

Line 1562: hr_utility.set_location('COPTIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);

1558: fetch c_bpp2 into l_bnft_prvdr_pool_id ;
1559: close c_bpp2;
1560: --
1561: end if;
1562: hr_utility.set_location('COPTIP Dn c_bpp2 '||l_bnft_prvdr_pool_id,20);
1563: -- Combination PLIP level
1564: --
1565: if l_bnft_prvdr_pool_id is null then
1566: --

Line 1574: hr_utility.set_location('COPTIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);

1570: fetch c_bpp5 into l_bnft_prvdr_pool_id, l_cmbn_plip_id ;
1571: close c_bpp5;
1572: --
1573: end if;
1574: hr_utility.set_location('COPTIP Dn c_bpp5 '||l_bnft_prvdr_pool_id,20);
1575: -- Now Find the pool at PTIP level
1576: --
1577: if l_bnft_prvdr_pool_id is null then
1578: --

Line 1584: hr_utility.set_location('COPTIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);

1580: fetch c_bpp3 into l_bnft_prvdr_pool_id ;
1581: close c_bpp3;
1582: --
1583: end if;
1584: hr_utility.set_location('COPTIP Dn c_bpp3 '||l_bnft_prvdr_pool_id,20);
1585: --
1586: -- Combination PTIP level
1587: --
1588: if l_bnft_prvdr_pool_id is null then

Line 1597: hr_utility.set_location('COPTIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);

1593: fetch c_bpp4 into l_bnft_prvdr_pool_id, l_cmbn_ptip_id ;
1594: close c_bpp4;
1595: --
1596: end if;
1597: hr_utility.set_location('COPTIP Dn c_bpp4 '||l_bnft_prvdr_pool_id,20);
1598: --
1599: -- Now Find the pool at Program level
1600: --
1601: if l_bnft_prvdr_pool_id is null then

Line 1608: hr_utility.set_location('COPTIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);

1604: fetch c_bpp1 into l_bnft_prvdr_pool_id ;
1605: close c_bpp1;
1606: --
1607: end if;
1608: hr_utility.set_location('COPTIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);
1609: -- Process COMBO PTIP Option
1610: if l_bnft_prvdr_pool_id is not null then
1611: --
1612: hr_utility.set_location('writing cmbnptipopt ',19 );

Line 1612: hr_utility.set_location('writing cmbnptipopt ',19 );

1608: hr_utility.set_location('COPTIP Dn c_bpp1 '||l_bnft_prvdr_pool_id,20);
1609: -- Process COMBO PTIP Option
1610: if l_bnft_prvdr_pool_id is not null then
1611: --
1612: hr_utility.set_location('writing cmbnptipopt ',19 );
1613: -- save cmbn id so we only write it once.
1614: l_write_this_one := 'Y';
1615: if l_wrote_cmbn.first is not null then
1616: for j in l_wrote_cmbn.first..l_wrote_cmbn.last loop

Line 1617: hr_utility.set_location('loop cmbns ptip/opts written '||

1613: -- save cmbn id so we only write it once.
1614: l_write_this_one := 'Y';
1615: if l_wrote_cmbn.first is not null then
1616: for j in l_wrote_cmbn.first..l_wrote_cmbn.last loop
1617: hr_utility.set_location('loop cmbns ptip/opts written '||
1618: to_char(l_wrote_cmbn(j)),30);
1619: if l_wrote_cmbn(j) = l_cmbn_ptip_opt_id then
1620: l_write_this_one := 'N';
1621: end if;

Line 1625: hr_utility.set_location('Write Cmbn Ptip Opt Lvl Flx Cr Distr Rec '||

1621: end if;
1622: end loop;
1623: end if;
1624: if l_write_this_one = 'Y' then
1625: hr_utility.set_location('Write Cmbn Ptip Opt Lvl Flx Cr Distr Rec '||
1626: to_char(l_cmbn_ptip_opt_id),30);
1627: l_wrote_cmbn(l_num_cmbn) := l_cmbn_ptip_opt_id;
1628: l_num_cmbn := l_num_cmbn+1;
1629: --

Line 1680: hr_utility.set_location('Dn BEPECAPI_CRE 6: ',10);

1676: p_request_id => fnd_global.conc_request_id,
1677: p_program_update_date => sysdate,
1678: p_object_version_number => l_object_version_number,
1679: p_effective_date => p_effective_date);
1680: hr_utility.set_location('Dn BEPECAPI_CRE 6: ',10);
1681: --
1682: end if;
1683: --
1684: end if;

Line 1692: hr_utility.set_location('Dn c_epe_oipl ',10);

1688: end if ; -- Override
1689: end if;
1690: close c_abr6;
1691: end loop;
1692: hr_utility.set_location('Dn c_epe_oipl ',10);
1693: end if;
1694:
1695:
1696: hr_utility.set_location('Leaving: '||l_proc,90);

Line 1696: hr_utility.set_location('Leaving: '||l_proc,90);

1692: hr_utility.set_location('Dn c_epe_oipl ',10);
1693: end if;
1694:
1695:
1696: hr_utility.set_location('Leaving: '||l_proc,90);
1697: --
1698: end main;
1699: --
1700: end ben_determine_elct_chc_flx_imp;