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.

[Home] [Help]

APPS.BEN_PLAN_BENEFICIARY_API dependencies on HR_UTILITY

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

89: order by pil.lf_evt_ocrd_dt asc;
90: --
91: begin
92: --
93: hr_utility.set_location('Entering:'|| l_proc, 10);
94: --
95: if fnd_global.conc_request_id = -1 then
96: --
97: ben_env_object.init(p_business_group_id => p_business_group_id,

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

122: End 5883382 - Get the earliest possible PIL for BNF
123: ***/
124: savepoint create_PLAN_BENEFICIARY;
125: --
126: hr_utility.set_location(l_proc, 20);
127: --
128: -- Process Logic
129: --
130: --

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

356: -- End of API User Hook for the after hook of create_PLAN_BENEFICIARY
357: --
358: end;
359: --
360: hr_utility.set_location(l_proc, 60);
361: --
362: -- When in validation only mode raise the Validate_Enabled exception
363: --
364: if p_validate then

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

371: p_effective_start_date := l_effective_start_date;
372: p_effective_end_date := l_effective_end_date;
373: p_object_version_number := l_object_version_number;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 70);
376: --
377: exception
378: --
379: when hr_api.validate_enabled then

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

390: p_pl_bnf_id := null;
391: p_effective_start_date := null;
392: p_effective_end_date := null;
393: p_object_version_number := null;
394: hr_utility.set_location(' Leaving:'||l_proc, 80);
395: --
396: when others then
397: --
398: -- A validation or unexpected error has occured

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

443: --
444: --
445: begin
446: --
447: hr_utility.set_location('Entering:'|| l_proc, 10);
448: --
449: if fnd_global.conc_request_id in (0,-1) then
450: --
451: ben_env_object.init(p_business_group_id => p_business_group_id,

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

457: p_benefit_action_id => null);
458: --
459: end if;
460: --
461: hr_utility.set_location(l_proc, 20);
462: --
463: --
464: if upper(p_validate) = 'TRUE'
465: then

Line 498: hr_utility.set_location(l_proc, 30);

494: ,p_effective_date => p_effective_date
495: ,p_multi_row_actn => l_multi_row_actn
496: );
497: --
498: hr_utility.set_location(l_proc, 30);
499: --
500: -- Set all output arguments
501: --
502: p_pl_bnf_id := l_pl_bnf_id;

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

503: p_effective_start_date := l_effective_start_date;
504: p_effective_end_date := l_effective_end_date;
505: p_object_version_number := l_object_version_number;
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 40);
508: --
509: exception
510: --
511: when others then

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

597: l_cmpltd_dt date;
598: --
599: begin
600: --
601: hr_utility.set_location('Entering:'|| l_proc, 10);
602: --
603: if fnd_global.conc_request_id = -1 then
604: --
605: ben_env_object.init(p_business_group_id => p_business_group_id,

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

615: -- Issue a savepoint if operating in validation only mode
616: --
617: savepoint update_PLAN_BENEFICIARY;
618: --
619: hr_utility.set_location(l_proc, 20);
620: --
621: -- Process Logic
622: --
623: l_object_version_number := p_object_version_number;

Line 804: hr_utility.set_location('through ' || p_dsgn_thru_dt ,99);

800: l2_datetrack_mode := 'ZAP';
801: --
802: end if;
803: --
804: hr_utility.set_location('through ' || p_dsgn_thru_dt ,99);
805: hr_utility.set_location('mode ' || l2_datetrack_mode ,99);
806: remove_usage(
807: p_validate => p_validate
808: ,p_pl_bnf_id => p_pl_bnf_id

Line 805: hr_utility.set_location('mode ' || l2_datetrack_mode ,99);

801: --
802: end if;
803: --
804: hr_utility.set_location('through ' || p_dsgn_thru_dt ,99);
805: hr_utility.set_location('mode ' || l2_datetrack_mode ,99);
806: remove_usage(
807: p_validate => p_validate
808: ,p_pl_bnf_id => p_pl_bnf_id
809: ,p_effective_date => p_effective_date

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

905: -- End of API User Hook for the after hook of update_PLAN_BENEFICIARY
906: --
907: end;
908: --
909: hr_utility.set_location(l_proc, 60);
910: --
911: -- When in validation only mode raise the Validate_Enabled exception
912: --
913: if p_validate then

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

919: p_object_version_number := l_object_version_number;
920: p_effective_start_date := l_effective_start_date;
921: p_effective_end_date := l_effective_end_date;
922: --
923: hr_utility.set_location(' Leaving:'||l_proc, 70);
924: --
925: exception
926: --
927: when hr_api.validate_enabled then

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

936: -- when validation only mode is being used.)
937: --
938: p_effective_start_date := null;
939: p_effective_end_date := null;
940: hr_utility.set_location(' Leaving:'||l_proc, 80);
941: --
942: when others then
943: --
944: -- A validation or unexpected error has occured

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

987: --
988: --
989: begin
990: --
991: hr_utility.set_location('Entering:'|| l_proc, 10);
992: --
993: if fnd_global.conc_request_id in (0,-1) then
994: --
995: ben_env_object.init(p_business_group_id => p_business_group_id,

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

1001: p_benefit_action_id => null);
1002: --
1003: end if;
1004: --
1005: hr_utility.set_location(l_proc, 20);
1006: --
1007: --
1008: if upper(p_validate) = 'TRUE'
1009: then

Line 1047: hr_utility.set_location(l_proc, 30);

1043: ,p_datetrack_mode => p_datetrack_mode
1044: ,p_multi_row_actn => l_multi_row_actn
1045: );
1046: --
1047: hr_utility.set_location(l_proc, 30);
1048: --
1049: -- Set all output arguments
1050: --
1051: p_effective_start_date := l_effective_start_date;

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

1051: p_effective_start_date := l_effective_start_date;
1052: p_effective_end_date := l_effective_end_date;
1053: p_object_version_number := l_object_version_number;
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 40);
1056: --
1057: exception
1058: --
1059: when others then

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

1134: --
1135: l_dummy varchar2(300);
1136: begin
1137: --
1138: hr_utility.set_location('Entering:'|| l_proc, 10);
1139: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1140: --mactec
1141: open c_pl_bnf(p_pl_bnf_id,p_effective_date);
1142: fetch c_pl_bnf into l_pl_bnf ;

Line 1139: hr_utility.set_location('p_effective_date'||p_effective_date,10);

1135: l_dummy varchar2(300);
1136: begin
1137: --
1138: hr_utility.set_location('Entering:'|| l_proc, 10);
1139: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1140: --mactec
1141: open c_pl_bnf(p_pl_bnf_id,p_effective_date);
1142: fetch c_pl_bnf into l_pl_bnf ;
1143: close c_pl_bnf ;

Line 1156: hr_utility.set_location('l_effective_date '||l_effective_date,10);

1152: l_effective_date := p_effective_date ;
1153: l_datetrack_mode := p_datetrack_mode ;
1154: end if;
1155: --
1156: hr_utility.set_location('l_effective_date '||l_effective_date,10);
1157: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
1158: --
1159: if fnd_global.conc_request_id = -1 then
1160: --

Line 1157: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);

1153: l_datetrack_mode := p_datetrack_mode ;
1154: end if;
1155: --
1156: hr_utility.set_location('l_effective_date '||l_effective_date,10);
1157: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
1158: --
1159: if fnd_global.conc_request_id = -1 then
1160: --
1161: ben_env_object.init(p_business_group_id => p_business_group_id,

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

1171: -- Issue a savepoint if operating in validation only mode
1172: --
1173: savepoint delete_PLAN_BENEFICIARY;
1174: --
1175: hr_utility.set_location(l_proc, 20);
1176: --
1177: -- Process Logic
1178: --
1179: l_object_version_number := p_object_version_number;

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

1351: -- End of API User Hook for the after hook of delete_PLAN_BENEFICIARY
1352: --
1353: end;
1354: --
1355: hr_utility.set_location(l_proc, 60);
1356: --
1357: -- When in validation only mode raise the Validate_Enabled exception
1358: --
1359: if p_validate then

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

1359: if p_validate then
1360: raise hr_api.validate_enabled;
1361: end if;
1362: --
1363: hr_utility.set_location(' Leaving:'||l_proc, 70);
1364: --
1365: exception
1366: --
1367: when hr_api.validate_enabled then

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

1418: l_multi_row_actn BOOLEAN;
1419: --
1420: begin
1421: --
1422: hr_utility.set_location('Entering:'|| l_proc, 10);
1423: --
1424: if fnd_global.conc_request_id in (0,-1) then
1425: --
1426: ben_env_object.init(p_business_group_id => p_business_group_id,

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

1432: p_benefit_action_id => null);
1433: --
1434: end if;
1435: --
1436: hr_utility.set_location(l_proc, 20);
1437: --
1438: --
1439: if upper(p_validate) = 'TRUE'
1440: then

Line 1475: hr_utility.set_location(l_proc, 30);

1471: ,p_datetrack_mode => p_datetrack_mode
1472: ,p_multi_row_actn => l_multi_row_actn
1473: );
1474: --
1475: hr_utility.set_location(l_proc, 30);
1476: --
1477: p_effective_start_date := l_effective_start_date;
1478: p_effective_end_date := l_effective_end_date;
1479: p_object_version_number := l_object_version_number;

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

1492: );
1493:
1494: --
1495: end if;
1496: hr_utility.set_location(' Leaving:'||l_proc, 40);
1497: --
1498: exception
1499: --
1500: when others then

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

1529: l_validation_end_date date;
1530: --
1531: begin
1532: --
1533: hr_utility.set_location('Entering:'|| l_proc, 10);
1534: --
1535: ben_pbn_shd.lck
1536: (
1537: p_pl_bnf_id => p_pl_bnf_id

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

1541: ,p_effective_date => p_effective_date
1542: ,p_datetrack_mode => p_datetrack_mode
1543: );
1544: --
1545: hr_utility.set_location(' Leaving:'||l_proc, 70);
1546: --
1547: end lck;
1548: --
1549: -- ----------------------------------------------------------------------------

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

1616: group by pbn.prmry_cntngnt_cd;
1617: --
1618: begin
1619: --
1620: hr_utility.set_location('Entering:'|| l_proc, 10);
1621: --
1622: if p_prtt_enrt_rslt_id is null or
1623: p_business_group_id is null or
1624: p_delete_flag = 'Y' then

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

1711: ,p_suspend_flag => l_suspend_flag
1712: ,p_bnf_actn_warning => l_bnf_actn_warning
1713: );
1714: --
1715: hr_utility.set_location('Exiting:'|| l_proc, 40);
1716: end bnf_actn_items;
1717: --
1718: --
1719: -- ----------------------------------------------------------------------------

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

1780: --
1781: --
1782: begin
1783: --
1784: hr_utility.set_location('Entering:'|| l_proc, 10);
1785: --
1786: l_enrt_cvg_strt_dt := null;
1787: l_dsg_strt_dt := p_effective_date;
1788: --

Line 1796: hr_utility.set_location('This is a person:'|| l_proc, 15);

1792: if p_bnf_person_id is not null then
1793: --
1794: -- get type id
1795: --
1796: hr_utility.set_location('This is a person:'|| l_proc, 15);
1797: -- dbms_output.put_line('This is a person '||to_char(p_bnf_person_id));
1798: --
1799: open get_bnf_type_id_c;
1800: fetch get_bnf_type_id_c into l_person_type_id;

Line 1803: hr_utility.set_location('Got BNF type ID:'|| l_proc, 20);

1799: open get_bnf_type_id_c;
1800: fetch get_bnf_type_id_c into l_person_type_id;
1801: if get_bnf_type_id_c%FOUND then
1802: --
1803: hr_utility.set_location('Got BNF type ID:'|| l_proc, 20);
1804: -- get cvg start dt
1805: open get_enrt_cvg_strt_dt_c;
1806: fetch get_enrt_cvg_strt_dt_c into l_enrt_cvg_strt_dt;
1807: close get_enrt_cvg_strt_dt_c;

Line 1816: hr_utility.set_location('Got start date:'|| l_proc, 25);

1812: if p_effective_date < l_enrt_cvg_strt_dt then
1813: l_dsg_strt_dt := l_enrt_cvg_strt_dt;
1814: end if;
1815: --
1816: hr_utility.set_location('Got start date:'|| l_proc, 25);
1817: -- dbms_output.put_line('Strt date is ' || to_char(l_dsg_strt_dt));
1818: --
1819: -- does BNF usage exist as of dsg strt date?
1820: --

Line 1827: hr_utility.set_location('No overlapping segments:'|| l_proc, 30);

1823: l_effective_end_date,
1824: l_person_type_usage_id;
1825: if find_ptu_ovlp_segments_c%NOTFOUND then
1826: --
1827: hr_utility.set_location('No overlapping segments:'|| l_proc, 30);
1828: -- dbms_output.put_line('No overlapping segments');
1829: -- call create person_type usage api
1830: --
1831: hr_per_type_usage_internal.create_person_type_usage

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

1878: close get_bnf_type_id_c;
1879: --
1880: end if;
1881: --
1882: hr_utility.set_location(' Leaving:'||l_proc, 70);
1883: --
1884: end add_usage;
1885: --
1886: -- ----------------------------------------------------------------------------

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

1959: l_usg_effective_start_date date;
1960: --
1961: begin
1962: --
1963: hr_utility.set_location('Entering'||l_proc, 5);
1964: hr_utility.set_location('mode '||p_datetrack_mode , 5);
1965: l_datetrack_mode := p_datetrack_mode;
1966: open bnf_person_c;
1967: fetch bnf_person_c into l_bnf_person_id,

Line 1964: hr_utility.set_location('mode '||p_datetrack_mode , 5);

1960: --
1961: begin
1962: --
1963: hr_utility.set_location('Entering'||l_proc, 5);
1964: hr_utility.set_location('mode '||p_datetrack_mode , 5);
1965: l_datetrack_mode := p_datetrack_mode;
1966: open bnf_person_c;
1967: fetch bnf_person_c into l_bnf_person_id,
1968: l_business_group_id;

Line 2011: hr_utility.set_location('Checking deletion in zap mode ',121);

2007: );
2008: --
2009: -- start bug 5668052
2010: elsif l_datetrack_mode = hr_api.g_zap then
2011: hr_utility.set_location('Checking deletion in zap mode ',121);
2012: open bnf_rec_exists(l_bnf_person_id);
2013: fetch bnf_rec_exists into l_dummy;
2014: if bnf_rec_exists%notfound then
2015:

Line 2016: hr_utility.set_location('Deleteing in zap mode ',121);

2012: open bnf_rec_exists(l_bnf_person_id);
2013: fetch bnf_rec_exists into l_dummy;
2014: if bnf_rec_exists%notfound then
2015:
2016: hr_utility.set_location('Deleteing in zap mode ',121);
2017: hr_per_type_usage_internal.delete_person_type_usage
2018: (p_validate => FALSE
2019: ,p_person_type_usage_id => l_person_type_usage_id
2020: ,p_effective_date => p_effective_date

Line 2028: hr_utility.set_location('Cant zap record exists ' || l_dummy,121);

2024: ,p_effective_start_date => l_effective_start_date
2025: ,p_effective_end_date => l_effective_end_date
2026: );
2027: else
2028: hr_utility.set_location('Cant zap record exists ' || l_dummy,121);
2029: end if;
2030: close bnf_rec_exists;
2031: end if;
2032: end if;

Line 2037: hr_utility.set_location(' other benefit found ' , 30);

2033: --
2034: close usage_c;
2035: --
2036: else
2037: hr_utility.set_location(' other benefit found ' , 30);
2038: end if;
2039: --
2040: close other_bnf_c;
2041: --

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

2040: close other_bnf_c;
2041: --
2042: end if;
2043: --
2044: hr_utility.set_location(' Leaving:'||l_proc, 70);
2045: --
2046: end remove_usage;
2047: --
2048: --