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

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

86: l_env_rec ben_env_object.g_global_env_rec_type;
87: --
88: begin
89: --
90: hr_utility.set_location('Entering:'|| l_proc, 10);
91: --
92: if fnd_global.conc_request_id = -1 then
93: --
94: ben_env_object.get(p_rec => l_env_rec);

Line 122: hr_utility.set_location(l_proc, 20);

118: --
119: end if;
120: --
121: --
122: hr_utility.set_location(l_proc, 20);
123: --
124: -- Process Logic
125: --
126: begin

Line 287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);

283: --
284: -- Added by pxdas for logging change event needed for extract.
285: -- p_erson control added to fox 5399
286:
287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);
288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);

Line 288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);

284: -- Added by pxdas for logging change event needed for extract.
285: -- p_erson control added to fox 5399
286:
287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);
288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);

Line 289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);

285: -- p_erson control added to fox 5399
286:
287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);
288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);
293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);

Line 290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);

286:
287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);
288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);
293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);
294:

Line 291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);

287: hr_utility.set_location('pl id '||l_chg_info.pl_id , 5399);
288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);
293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);
294:
295: if p_dpnt_person_id is not null then

Line 292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);

288: hr_utility.set_location('oipl id '||l_chg_info.oipl_id , 5399);
289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);
293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);
294:
295: if p_dpnt_person_id is not null then
296: --

Line 293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);

289: hr_utility.set_location('prt_enrt_rslt id '||p_prtt_enrt_rslt_id , 5399);
290: hr_utility.set_location('person id '||l_chg_info.person_id , 5399);
291: hr_utility.set_location('dpndnt id '||p_dpnt_person_id , 5399);
292: hr_utility.set_location('per_in_ler id '||p_per_in_ler_id , 5399);
293: hr_utility.set_location(' idg_cvrd_dpnt_id '||p_elig_cvrd_dpnt_id , 5399);
294:
295: if p_dpnt_person_id is not null then
296: --
297: open c_chg_info (p_prtt_enrt_rslt_id);

Line 393: hr_utility.set_location(l_proc, 60);

389: -- End of API User Hook for the after hook of create_ELIG_CVRD_DPNT
390: --
391: end;
392: --
393: hr_utility.set_location(l_proc, 60);
394: --
395: -- When in validation only mode raise the Validate_Enabled exception
396: --
397: if p_validate then

Line 408: hr_utility.set_location(' Leaving:'||l_proc, 70);

404: p_effective_start_date := l_effective_start_date;
405: p_effective_end_date := l_effective_end_date;
406: p_object_version_number := l_object_version_number;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: exception
411: --
412: when hr_api.validate_enabled then

Line 427: hr_utility.set_location(' Leaving:'||l_proc, 80);

423: p_elig_cvrd_dpnt_id := null;
424: p_effective_start_date := null;
425: p_effective_end_date := null;
426: p_object_version_number := null;
427: hr_utility.set_location(' Leaving:'||l_proc, 80);
428: --
429: when others then
430: --
431: -- A validation or unexpected error has occured

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

585: --
586: --
587: begin
588: --
589: hr_utility.set_location('Entering:'|| l_proc, 10);
590: hr_utility.set_location('per in ler id '|| p_per_in_ler_id , 9745);
591: hr_utility.set_location('elig_dpnt ' || p_elig_cvrd_dpnt_id, 9745);
592: hr_utility.set_location(' dt' || p_effective_start_date, 9745);
593: --

Line 590: hr_utility.set_location('per in ler id '|| p_per_in_ler_id , 9745);

586: --
587: begin
588: --
589: hr_utility.set_location('Entering:'|| l_proc, 10);
590: hr_utility.set_location('per in ler id '|| p_per_in_ler_id , 9745);
591: hr_utility.set_location('elig_dpnt ' || p_elig_cvrd_dpnt_id, 9745);
592: hr_utility.set_location(' dt' || p_effective_start_date, 9745);
593: --
594: if fnd_global.conc_request_id = -1 then

Line 591: hr_utility.set_location('elig_dpnt ' || p_elig_cvrd_dpnt_id, 9745);

587: begin
588: --
589: hr_utility.set_location('Entering:'|| l_proc, 10);
590: hr_utility.set_location('per in ler id '|| p_per_in_ler_id , 9745);
591: hr_utility.set_location('elig_dpnt ' || p_elig_cvrd_dpnt_id, 9745);
592: hr_utility.set_location(' dt' || p_effective_start_date, 9745);
593: --
594: if fnd_global.conc_request_id = -1 then
595: --

Line 592: hr_utility.set_location(' dt' || p_effective_start_date, 9745);

588: --
589: hr_utility.set_location('Entering:'|| l_proc, 10);
590: hr_utility.set_location('per in ler id '|| p_per_in_ler_id , 9745);
591: hr_utility.set_location('elig_dpnt ' || p_elig_cvrd_dpnt_id, 9745);
592: hr_utility.set_location(' dt' || p_effective_start_date, 9745);
593: --
594: if fnd_global.conc_request_id = -1 then
595: --
596: ben_env_object.get(p_rec => l_env_rec);

Line 615: hr_utility.set_location(l_proc, 20);

611: -- Issue a savepoint if operating in validation only mode
612: --
613: savepoint update_ELIG_CVRD_DPNT;
614: --
615: hr_utility.set_location(l_proc, 20);
616: --
617: -- Process Logic
618: --
619: l_object_version_number := p_object_version_number;

Line 793: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);

789: l_pcp_effective_date := NVL(p_cvg_thru_dt+1,p_effective_date);
790: --
791: for l_pcp in c_pcp(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
792: --
793: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
794: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
795: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
796: hr_utility.set_location('DATETRACK_MODE '|| l2_datetrack_mode, 15);
797: --

Line 794: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);

790: --
791: for l_pcp in c_pcp(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
792: --
793: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
794: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
795: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
796: hr_utility.set_location('DATETRACK_MODE '|| l2_datetrack_mode, 15);
797: --
798: -- Since, deletion automatically sets end-date to 1 day less than effective-date,

Line 795: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);

791: for l_pcp in c_pcp(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
792: --
793: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
794: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
795: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
796: hr_utility.set_location('DATETRACK_MODE '|| l2_datetrack_mode, 15);
797: --
798: -- Since, deletion automatically sets end-date to 1 day less than effective-date,
799: -- call the delete-api with effective_date = cvg_thru_date+1.

Line 796: hr_utility.set_location('DATETRACK_MODE '|| l2_datetrack_mode, 15);

792: --
793: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
794: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
795: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
796: hr_utility.set_location('DATETRACK_MODE '|| l2_datetrack_mode, 15);
797: --
798: -- Since, deletion automatically sets end-date to 1 day less than effective-date,
799: -- call the delete-api with effective_date = cvg_thru_date+1.
800: --

Line 818: hr_utility.set_location('ZAP prmry_care_prvdr_id '|| l_pcp_future.prmry_care_prvdr_id, 15);

814: -- Get future PCP records if any and zap - delete all of them.
815: --
816: for l_pcp_future in c_pcp_future(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
817: --
818: hr_utility.set_location('ZAP prmry_care_prvdr_id '|| l_pcp_future.prmry_care_prvdr_id, 15);
819: hr_utility.set_location('PCP ESD: EED '|| l_pcp_future.effective_start_date ||': '||l_pcp_future.effective_end_date, 15);
820: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_start_date, 15);
821: --
822: l_pcp_effective_start_date := l_pcp_future.effective_start_date;

Line 819: hr_utility.set_location('PCP ESD: EED '|| l_pcp_future.effective_start_date ||': '||l_pcp_future.effective_end_date, 15);

815: --
816: for l_pcp_future in c_pcp_future(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
817: --
818: hr_utility.set_location('ZAP prmry_care_prvdr_id '|| l_pcp_future.prmry_care_prvdr_id, 15);
819: hr_utility.set_location('PCP ESD: EED '|| l_pcp_future.effective_start_date ||': '||l_pcp_future.effective_end_date, 15);
820: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_start_date, 15);
821: --
822: l_pcp_effective_start_date := l_pcp_future.effective_start_date;
823: --

Line 820: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_start_date, 15);

816: for l_pcp_future in c_pcp_future(p_elig_cvrd_dpnt_id, l_pcp_effective_date) loop
817: --
818: hr_utility.set_location('ZAP prmry_care_prvdr_id '|| l_pcp_future.prmry_care_prvdr_id, 15);
819: hr_utility.set_location('PCP ESD: EED '|| l_pcp_future.effective_start_date ||': '||l_pcp_future.effective_end_date, 15);
820: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_start_date, 15);
821: --
822: l_pcp_effective_start_date := l_pcp_future.effective_start_date;
823: --
824: ben_prmry_care_prvdr_api.delete_prmry_care_prvdr

Line 1002: hr_utility.set_location(l_proc, 60);

998: -- End of API User Hook for the after hook of update_ELIG_CVRD_DPNT
999: --
1000: end;
1001: --
1002: hr_utility.set_location(l_proc, 60);
1003: --
1004: -- When in validation only mode raise the Validate_Enabled exception
1005: --
1006: if p_validate then

Line 1016: hr_utility.set_location(' Leaving:'||l_proc, 70);

1012: p_object_version_number := l_object_version_number;
1013: p_effective_start_date := l_effective_start_date;
1014: p_effective_end_date := l_effective_end_date;
1015: --
1016: hr_utility.set_location(' Leaving:'||l_proc, 70);
1017: --
1018: exception
1019: --
1020: when hr_api.validate_enabled then

Line 1033: hr_utility.set_location(' Leaving:'||l_proc, 80);

1029: -- when validation only mode is being used.)
1030: --
1031: p_effective_start_date := null;
1032: p_effective_end_date := null;
1033: hr_utility.set_location(' Leaving:'||l_proc, 80);
1034: --
1035: when others then
1036: --
1037: -- A validation or unexpected error has occured

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

1156:
1157: begin
1158: --
1159:
1160: hr_utility.set_location(' Entering:'||l_proc, 10);
1161:
1162: open get_dpnt_info_c;
1163: fetch get_dpnt_info_c into l_dpnt_person_id,
1164: l_cvg_strt_dt,

Line 1175: hr_utility.set_location('Dependent Person Id : '||l_dpnt_person_id , 20);

1171: end if;
1172: --
1173: close get_dpnt_info_c;
1174:
1175: hr_utility.set_location('Dependent Person Id : '||l_dpnt_person_id , 20);
1176:
1177: --
1178: if p_cvg_thru_dt is not null then
1179: l_end_dt := p_cvg_thru_dt;

Line 1210: hr_utility.set_location('Delete Person Type Usage Id : '||del_rec.person_type_usage_id , 30);

1206: ,p_object_version_number => del_rec.object_version_number
1207: ,p_effective_start_date => del_rec.effective_start_date
1208: ,p_effective_end_date => del_rec.effective_end_date
1209: );
1210: hr_utility.set_location('Delete Person Type Usage Id : '||del_rec.person_type_usage_id , 30);
1211: end loop;
1212:
1213:
1214: -- set the effective_end_date to end-of-time

Line 1225: hr_utility.set_location('Un-end-date Person Type Usage Id : '||cur_rec.person_type_usage_id , 30);

1221: set effective_end_date = l_effective_end_date
1222: where ptu.person_type_usage_id = cur_rec.person_type_usage_id
1223: and ptu.effective_start_date = cur_rec.effective_start_date;
1224:
1225: hr_utility.set_location('Un-end-date Person Type Usage Id : '||cur_rec.person_type_usage_id , 30);
1226: end loop;
1227: --
1228: end if;
1229: --

Line 1232: hr_utility.set_location(' Leaving:'||l_proc, 40);

1228: end if;
1229: --
1230: close other_dpnt_c;
1231: --
1232: hr_utility.set_location(' Leaving:'||l_proc, 40);
1233: --
1234: end un_end_date_dpnt_ptu;
1235:
1236: ----------------------------------------------------------------------------

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

1313: l_datetrack_mode varchar2(30);
1314: --
1315: begin
1316: --
1317: hr_utility.set_location(' Entering:'||l_proc, 10);
1318: --
1319: open c_get_dpnt_info;
1320: fetch c_get_dpnt_info into l_dpnt_person_id,
1321: l_cvg_strt_dt,

Line 1332: hr_utility.set_location('Dependent Person Id : '||l_dpnt_person_id , 20);

1328: end if;
1329: --
1330: close c_get_dpnt_info;
1331:
1332: hr_utility.set_location('Dependent Person Id : '||l_dpnt_person_id , 20);
1333: --
1334: for l_usage_pea in c_pea(l_prtt_enrt_rslt_id)
1335: loop
1336: --

Line 1356: hr_utility.set_location(' Leaving:'||l_proc, 40);

1352: end if;
1353: --
1354: end loop;
1355: --
1356: hr_utility.set_location(' Leaving:'||l_proc, 40);
1357: --
1358: end un_end_date_dpnt_pea;
1359:
1360: -- ----------------------------------------------------------------------------

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

1462: l_env_rec ben_env_object.g_global_env_rec_type;
1463: --
1464: begin
1465: --
1466: hr_utility.set_location('Entering:'|| l_proc, 10);
1467: if ben_back_out_life_event.g_bolfe_effective_date is not null then
1468: l_child_effective_date:=ben_back_out_life_event.g_bolfe_effective_date;
1469: else
1470: l_child_effective_date:=p_effective_date;

Line 1494: hr_utility.set_location(l_proc, 20);

1490: -- Issue a savepoint if operating in validation only mode
1491: --
1492: savepoint delete_ELIG_CVRD_DPNT;
1493: --
1494: hr_utility.set_location(l_proc, 20);
1495: --
1496: -- Process Logic
1497: --
1498: l_object_version_number := p_object_version_number;

Line 1558: hr_utility.set_location('ACE l_dpnt_pcp_actn_typ_id = ' ||l_dpnt_pcp_actn_typ_id, 9999);

1554: (p_type_cd => 'PCPDPNT',
1555: p_business_group_id => p_business_group_id
1556: );
1557: --
1558: hr_utility.set_location('ACE l_dpnt_pcp_actn_typ_id = ' ||l_dpnt_pcp_actn_typ_id, 9999);
1559: --
1560: FOR l_dpnt_pcp_actn_item_rec IN c_dpnt_pcp_actn_item
1561: LOOP
1562: --

Line 1563: hr_utility.set_location ('ACE prtt_enrt_actn_id = ' || l_dpnt_pcp_actn_item_rec.prtt_enrt_actn_id, 9999);

1559: --
1560: FOR l_dpnt_pcp_actn_item_rec IN c_dpnt_pcp_actn_item
1561: LOOP
1562: --
1563: hr_utility.set_location ('ACE prtt_enrt_actn_id = ' || l_dpnt_pcp_actn_item_rec.prtt_enrt_actn_id, 9999);
1564: --
1565: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1566: --
1567: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api

Line 1742: hr_utility.set_location(l_proc, 60);

1738: -- End of API User Hook for the after hook of delete_ELIG_CVRD_DPNT
1739: --
1740: end;
1741: --
1742: hr_utility.set_location(l_proc, 60);
1743: --
1744: -- When in validation only mode raise the Validate_Enabled exception
1745: --
1746: if p_validate then

Line 1750: hr_utility.set_location(' Leaving:'||l_proc, 70);

1746: if p_validate then
1747: raise hr_api.validate_enabled;
1748: end if;
1749: --
1750: hr_utility.set_location(' Leaving:'||l_proc, 70);
1751: --
1752: exception
1753: --
1754: when hr_api.validate_enabled then

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

1881: l_env_rec ben_env_object.g_global_env_rec_type;
1882: --
1883: begin
1884: --
1885: hr_utility.set_location('Entering:'|| l_proc, 10);
1886: if ben_back_out_life_event.g_bolfe_effective_date is not null then
1887: l_child_effective_date:=ben_back_out_life_event.g_bolfe_effective_date;
1888: else
1889: l_child_effective_date:=p_effective_date;

Line 1913: hr_utility.set_location(l_proc, 20);

1909: -- Issue a savepoint if operating in validation only mode
1910: --
1911: savepoint delete_ELIG_CVRD_DPNT;
1912: --
1913: hr_utility.set_location(l_proc, 20);
1914: --
1915: -- Process Logic
1916: --
1917: l_object_version_number := p_object_version_number;

Line 1978: hr_utility.set_location('ACE l_dpnt_pcp_actn_typ_id = ' ||l_dpnt_pcp_actn_typ_id, 9999);

1974: (p_type_cd => 'PCPDPNT',
1975: p_business_group_id => p_business_group_id
1976: );
1977: --
1978: hr_utility.set_location('ACE l_dpnt_pcp_actn_typ_id = ' ||l_dpnt_pcp_actn_typ_id, 9999);
1979: --
1980: FOR l_dpnt_pcp_actn_item_rec IN c_dpnt_pcp_actn_item
1981: LOOP
1982: --

Line 1983: hr_utility.set_location ('ACE prtt_enrt_actn_id = ' || l_dpnt_pcp_actn_item_rec.prtt_enrt_actn_id, 9999);

1979: --
1980: FOR l_dpnt_pcp_actn_item_rec IN c_dpnt_pcp_actn_item
1981: LOOP
1982: --
1983: hr_utility.set_location ('ACE prtt_enrt_actn_id = ' || l_dpnt_pcp_actn_item_rec.prtt_enrt_actn_id, 9999);
1984: --
1985: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1986: --
1987: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api

Line 2185: hr_utility.set_location(l_proc, 60);

2181: -- End of API User Hook for the after hook of delete_ELIG_CVRD_DPNT
2182: --
2183: end;
2184: --
2185: hr_utility.set_location(l_proc, 60);
2186: --
2187: -- When in validation only mode raise the Validate_Enabled exception
2188: --
2189: if p_validate then

Line 2193: hr_utility.set_location(' Leaving:'||l_proc, 70);

2189: if p_validate then
2190: raise hr_api.validate_enabled;
2191: end if;
2192: --
2193: hr_utility.set_location(' Leaving:'||l_proc, 70);
2194: --
2195: exception
2196: --
2197: when hr_api.validate_enabled then

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

2237: l_validation_end_date date;
2238: --
2239: begin
2240: --
2241: hr_utility.set_location('Entering:'|| l_proc, 10);
2242: --
2243: ben_pdp_shd.lck
2244: (
2245: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id

Line 2253: hr_utility.set_location(' Leaving:'||l_proc, 70);

2249: ,p_effective_date => p_effective_date
2250: ,p_datetrack_mode => p_datetrack_mode
2251: );
2252: --
2253: hr_utility.set_location(' Leaving:'||l_proc, 70);
2254: --
2255: end lck;
2256: --
2257: -- ----------------------------------------------------------------------------

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

2298: and p_effective_date < enrt_cvg_thru_dt ; -- 5173425: Need not determine dpnts for End-dated enrollments.
2299: --
2300: begin
2301: --
2302: hr_utility.set_location('Entering:'|| l_proc, 10);
2303: --
2304: if p_prtt_enrt_rslt_id is null or
2305: p_business_group_id is null then
2306: open get_rslt_id_c;

Line 2351: hr_utility.set_location('Exiting:'|| l_proc, 40);

2347: end if; -- 5173425
2348: --
2349: end if;
2350: --
2351: hr_utility.set_location('Exiting:'|| l_proc, 40);
2352: --
2353: end dpnt_actn_items;
2354: --
2355: --

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

2421: ;
2422: --
2423: begin
2424: --
2425: hr_utility.set_location('Entering:'|| l_proc, 10);
2426: --
2427: open get_dpnt_info_c;
2428: fetch get_dpnt_info_c into l_dpnt_person_id,
2429: l_cvg_strt_dt,

Line 2519: hr_utility.set_location(' Leaving:'||l_proc, 70);

2515: --
2516: close get_dpnt_type_id_c;
2517: --
2518: --
2519: hr_utility.set_location(' Leaving:'||l_proc, 70);
2520: --
2521: end add_usage;
2522: --
2523: --

Line 2632: hr_utility.set_location(' Leaving:'||l_proc, 64);

2628: l_datetrack_mode := 'DELETE';
2629: if l_eff_end_date=l_end_dt then
2630: close usage_c;
2631: close other_dpnt_c;
2632: hr_utility.set_location(' Leaving:'||l_proc, 64);
2633: return;
2634: end if;
2635: else
2636: l_datetrack_mode := 'ZAP';

Line 2645: hr_utility.set_location(' Leaving:'||l_proc, 65);

2641: elsif p_datetrack_mode=hr_api.g_delete and
2642: l_eff_end_date=l_end_dt then
2643: close usage_c;
2644: close other_dpnt_c;
2645: hr_utility.set_location(' Leaving:'||l_proc, 65);
2646: return;
2647: elsif p_cvg_thru_dt < l_eff_strt_date then -- 5655342
2648: l_datetrack_mode := 'ZAP';
2649: else

Line 2670: hr_utility.set_location(' Leaving:'||l_proc, 70);

2666: end if;
2667: --
2668: close other_dpnt_c;
2669: --
2670: hr_utility.set_location(' Leaving:'||l_proc, 70);
2671: --
2672: end remove_usage;
2673: --
2674: --

Line 2919: hr_utility.set_location('Entering:'||l_proc,5);

2915: --
2916:
2917: Begin
2918: --
2919: hr_utility.set_location('Entering:'||l_proc,5);
2920: --
2921: if p_prtt_enrt_rslt_id is not null then
2922: --
2923: hr_utility.set_location('open info1_c :'||l_proc,10);

Line 2923: hr_utility.set_location('open info1_c :'||l_proc,10);

2919: hr_utility.set_location('Entering:'||l_proc,5);
2920: --
2921: if p_prtt_enrt_rslt_id is not null then
2922: --
2923: hr_utility.set_location('open info1_c :'||l_proc,10);
2924: --
2925: for l_pen_pdp_rec in info1_c loop
2926: --
2927: open info2_c(l_pen_pdp_rec.person_id,

Line 2941: hr_utility.set_location(l_proc, 12);

2937: fnd_message.raise_error;
2938: --
2939: else
2940: -- Check if there are any requirements at all
2941: hr_utility.set_location(l_proc, 12);
2942: close info2_c;
2943: open any_rqmt_c(l_pen_pdp_rec.pl_id,
2944: l_pen_pdp_rec.oipl_id,
2945: l_pen_pdp_rec.opt_id);

Line 2953: hr_utility.set_location(l_proc, 15);

2949: if any_rqmt_c%found then
2950: --
2951: close any_rqmt_c;
2952: -- Check total max requirement
2953: hr_utility.set_location(l_proc, 15);
2954: open total_rqmt_c(l_pen_pdp_rec.pl_id,
2955: l_pen_pdp_rec.oipl_id,
2956: l_pen_pdp_rec.opt_id);
2957: fetch total_rqmt_c into

Line 2974: hr_utility.set_location('total_mx '||to_char(l_t_mx_dpnts_alwd_num)||

2970: l_pen_pdp_rec.cvg_thru_dt);
2971: fetch total_num_dpnt_c into l_total_num_dpnt;
2972: close total_num_dpnt_c;
2973:
2974: hr_utility.set_location('total_mx '||to_char(l_t_mx_dpnts_alwd_num)||
2975: 'total_dpnt '||l_total_num_dpnt, 18);
2976:
2977:
2978: if l_total_num_dpnt > l_t_mx_dpnts_alwd_num then

Line 2989: hr_utility.set_location('LAMC: l_contact_type '||l_contact_type,30);

2985: end if; -- l_t_no_mx_num_dfnd_flag = 'N'
2986: end if; -- total_rqmt_c
2987:
2988: -- Check max requirement for relationship type
2989: hr_utility.set_location('LAMC: l_contact_type '||l_contact_type,30);
2990: hr_utility.set_location('l_opt_id '||to_char(l_pen_pdp_rec.opt_id),30);
2991: hr_utility.set_location('l_oipl_id '||to_char(l_pen_pdp_rec.oipl_id), 30);
2992:
2993: open rlshp_rqmt_c(l_pen_pdp_rec.pl_id,

Line 2990: hr_utility.set_location('l_opt_id '||to_char(l_pen_pdp_rec.opt_id),30);

2986: end if; -- total_rqmt_c
2987:
2988: -- Check max requirement for relationship type
2989: hr_utility.set_location('LAMC: l_contact_type '||l_contact_type,30);
2990: hr_utility.set_location('l_opt_id '||to_char(l_pen_pdp_rec.opt_id),30);
2991: hr_utility.set_location('l_oipl_id '||to_char(l_pen_pdp_rec.oipl_id), 30);
2992:
2993: open rlshp_rqmt_c(l_pen_pdp_rec.pl_id,
2994: l_pen_pdp_rec.oipl_id,

Line 2991: hr_utility.set_location('l_oipl_id '||to_char(l_pen_pdp_rec.oipl_id), 30);

2987:
2988: -- Check max requirement for relationship type
2989: hr_utility.set_location('LAMC: l_contact_type '||l_contact_type,30);
2990: hr_utility.set_location('l_opt_id '||to_char(l_pen_pdp_rec.opt_id),30);
2991: hr_utility.set_location('l_oipl_id '||to_char(l_pen_pdp_rec.oipl_id), 30);
2992:
2993: open rlshp_rqmt_c(l_pen_pdp_rec.pl_id,
2994: l_pen_pdp_rec.oipl_id,
2995: l_pen_pdp_rec.opt_id,

Line 3008: hr_utility.set_location('No rlshp rqmts', 20);

3004:
3005: if rlshp_rqmt_c%notfound then
3006:
3007: -- No rqmts for this relationship type, do not allow dsgn.
3008: hr_utility.set_location('No rlshp rqmts', 20);
3009: close rlshp_rqmt_c;
3010: fnd_message.set_name('BEN', 'BEN_91971_NO_DPNTS_ALWD');
3011: fnd_message.raise_error;
3012:

Line 3014: hr_utility.set_location('total_rlshp_mx '||to_char(l_r_mx_dpnts_alwd_num), 20);

3010: fnd_message.set_name('BEN', 'BEN_91971_NO_DPNTS_ALWD');
3011: fnd_message.raise_error;
3012:
3013: else
3014: hr_utility.set_location('total_rlshp_mx '||to_char(l_r_mx_dpnts_alwd_num), 20);
3015: close rlshp_rqmt_c;
3016: if l_r_no_mx_num_dfnd_flag = 'N' then
3017:
3018: hr_utility.set_location('l_dsgn_rqmt_id'||to_char(l_dsgn_rqmt_id),30);

Line 3018: hr_utility.set_location('l_dsgn_rqmt_id'||to_char(l_dsgn_rqmt_id),30);

3014: hr_utility.set_location('total_rlshp_mx '||to_char(l_r_mx_dpnts_alwd_num), 20);
3015: close rlshp_rqmt_c;
3016: if l_r_no_mx_num_dfnd_flag = 'N' then
3017:
3018: hr_utility.set_location('l_dsgn_rqmt_id'||to_char(l_dsgn_rqmt_id),30);
3019: hr_utility.set_location('l_person_id'||to_char(l_pen_pdp_rec.person_id),30);
3020: open rlshp_num_dpnt_c(l_pen_pdp_rec.person_id,
3021: l_pen_pdp_rec.cvg_strt_dt,
3022: l_pen_pdp_rec.cvg_thru_dt);

Line 3019: hr_utility.set_location('l_person_id'||to_char(l_pen_pdp_rec.person_id),30);

3015: close rlshp_rqmt_c;
3016: if l_r_no_mx_num_dfnd_flag = 'N' then
3017:
3018: hr_utility.set_location('l_dsgn_rqmt_id'||to_char(l_dsgn_rqmt_id),30);
3019: hr_utility.set_location('l_person_id'||to_char(l_pen_pdp_rec.person_id),30);
3020: open rlshp_num_dpnt_c(l_pen_pdp_rec.person_id,
3021: l_pen_pdp_rec.cvg_strt_dt,
3022: l_pen_pdp_rec.cvg_thru_dt);
3023: fetch rlshp_num_dpnt_c into l_rlshp_num_dpnt;

Line 3025: hr_utility.set_location('rlshp_dpnt_mx '||to_char(l_rlshp_num_dpnt), 30);

3021: l_pen_pdp_rec.cvg_strt_dt,
3022: l_pen_pdp_rec.cvg_thru_dt);
3023: fetch rlshp_num_dpnt_c into l_rlshp_num_dpnt;
3024: close rlshp_num_dpnt_c;
3025: hr_utility.set_location('rlshp_dpnt_mx '||to_char(l_rlshp_num_dpnt), 30);
3026:
3027: if l_rlshp_num_dpnt > l_r_mx_dpnts_alwd_num then
3028:
3029: -- error as # of cov dependents of this rel type will exceed max

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

3065: end if; -- info2_c%notfound
3066: end loop; -- info1_c
3067: end if; -- p_prtt_enrt_rslt_id is not null
3068: --
3069: hr_utility.set_location('Leaving:'||l_proc,99);
3070: --
3071: end chk_max_num_dpnt_for_pen;
3072: --
3073: --