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

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

126: l_fonm_rt_strt_dt date ;
127:
128: -- eof FONM
129: begin
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: -- bof FONM
132: if l_fonm_flag = 'Y' then
133: l_fonm_cvg_strt_dt := p_enrt_cvg_strt_dt ;
134: l_fonm_rt_strt_dt := p_rt_strt_dt ;

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

154: l_fonm_eff_dt := nvl(l_epe_row.fonm_cvg_strt_dt, p_effective_date ) ;
155: --
156: end if ;
157: -- eof FONM
158: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);
161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);
162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);

Line 159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);

155: --
156: end if ;
157: -- eof FONM
158: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);
161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);
162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);
163:

Line 160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);

156: end if ;
157: -- eof FONM
158: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);
161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);
162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);
163:
164: if p_std_prem_val is null or p_actl_prem_id is null or p_prtt_enrt_rslt_id is null

Line 161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);

157: -- eof FONM
158: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);
161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);
162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);
163:
164: if p_std_prem_val is null or p_actl_prem_id is null or p_prtt_enrt_rslt_id is null
165: then

Line 162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);

158: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
159: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
160: hr_utility.set_location('p_enrt_cvg_strt_dt:'|| p_enrt_cvg_strt_dt, 10);
161: hr_utility.set_location('l_fonm_date:'|| l_fonm_date, 10);
162: hr_utility.set_location('l_fonm_eff_date:'|| l_fonm_eff_dt, 10);
163:
164: if p_std_prem_val is null or p_actl_prem_id is null or p_prtt_enrt_rslt_id is null
165: then
166: if p_prtt_prem_id is null then

Line 180: hr_utility.set_location('BEN_91563_BENVRBRT_APR_NF', 11);

176: open c_prtt_prem(l_fonm_date);
177: fetch c_prtt_prem into l_prtt_prem;
178: if c_prtt_prem%NOTFOUND or c_prtt_prem%NOTFOUND is null then
179: close c_prtt_prem;
180: hr_utility.set_location('BEN_91563_BENVRBRT_APR_NF', 11);
181: fnd_message.set_name('BEN', 'BEN_91563_BENVRBRT_APR_NF');
182: fnd_message.raise_error;
183: end if;
184: close c_prtt_prem;

Line 196: hr_utility.set_location('BEN_91577_BENACPRM_APR_NF', 20);

192: open c_actl_prem(l_prtt_prem.actl_prem_id,l_fonm_date );
193: fetch c_actl_prem into l_actl_prem;
194: if c_actl_prem%NOTFOUND or c_actl_prem%NOTFOUND is null then
195: close c_actl_prem;
196: hr_utility.set_location('BEN_91577_BENACPRM_APR_NF', 20);
197: fnd_message.set_name('BEN', 'BEN_91577_BENACPRM_APR_NF');
198: fnd_message.raise_error;
199: end if;
200: close c_actl_prem;

Line 218: hr_utility.set_location('BEN_92494_COVERAGE_NF', 30);

214: open c_cvg(l_actl_prem.pl_id, l_actl_prem.oipl_id,l_fonm_date);
215: fetch c_cvg into l_cvg;
216: if c_cvg%NOTFOUND then
217: close c_cvg;
218: hr_utility.set_location('BEN_92494_COVERAGE_NF', 30);
219: fnd_message.set_name('BEN', 'BEN_92492_COVERAGE_NF');
220: fnd_message.set_token('ID', to_char(l_prtt_prem.actl_prem_id));
221: fnd_message.raise_error;
222: end if;

Line 247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);

243: open c_rslt(l_prtt_prem.prtt_enrt_rslt_id);
244: fetch c_rslt into l_rslt;
245: if c_rslt%NOTFOUND or c_rslt%NOTFOUND is null then
246: close c_rslt;
247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);
248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);

Line 301: hr_utility.set_location('p_std_prem_val:'||to_char(p_std_prem_val), 99);

297: p_computed_val => p_std_prem_val); -- output
298:
299: end if;
300: --end if;
301: hr_utility.set_location('p_std_prem_val:'||to_char(p_std_prem_val), 99);
302: hr_utility.set_location('Leaving:'|| l_proc, 99);
303: end recalc_PRTT_PREM;
304: --
305: -- ----------------------------------------------------------------------------

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

298:
299: end if;
300: --end if;
301: hr_utility.set_location('p_std_prem_val:'||to_char(p_std_prem_val), 99);
302: hr_utility.set_location('Leaving:'|| l_proc, 99);
303: end recalc_PRTT_PREM;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |------------------------< create_PRTT_PREM >----------------------|

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

365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
366: --
367: begin
368: --
369: hr_utility.set_location('Entering:'|| l_proc, 10);
370: --
371: -- Issue a savepoint if operating in validation only mode
372: --
373: savepoint create_PRTT_PREM;

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

371: -- Issue a savepoint if operating in validation only mode
372: --
373: savepoint create_PRTT_PREM;
374: --
375: hr_utility.set_location(l_proc, 20);
376: --
377: -- Process Logic
378: --
379: begin

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

550: -- End of API User Hook for the after hook of create_PRTT_PREM
551: --
552: end;
553: --
554: hr_utility.set_location(l_proc, 60);
555: --
556: -- When in validation only mode raise the Validate_Enabled exception
557: --
558: if p_validate then

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

565: p_effective_start_date := l_effective_start_date;
566: p_effective_end_date := l_effective_end_date;
567: p_object_version_number := l_object_version_number;
568: --
569: hr_utility.set_location(' Leaving:'||l_proc, 70);
570: --
571: exception
572: --
573: when hr_api.validate_enabled then

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

584: p_prtt_prem_id := null;
585: p_effective_start_date := null;
586: p_effective_end_date := null;
587: p_object_version_number := null;
588: hr_utility.set_location(' Leaving:'||l_proc, 80);
589: --
590: when others then
591: --
592: -- A validation or unexpected error has occured

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

668: pen.effective_start_date and pen.effective_end_date;
669: --
670: begin
671: --
672: hr_utility.set_location('Entering:'|| l_proc, 10);
673: --
674: -- Issue a savepoint if operating in validation only mode
675: --
676: savepoint create_PRTT_PREM;

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

678: open c_per_in_ler;
679: fetch c_per_in_ler into l_per_in_ler_id;
680: close c_per_in_ler;
681: --
682: hr_utility.set_location(l_proc, 20);
683: --
684: -- Process Logic
685: --
686: begin

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

857: -- End of API User Hook for the after hook of create_PRTT_PREM
858: --
859: end;
860: --
861: hr_utility.set_location(l_proc, 60);
862: --
863: -- When in validation only mode raise the Validate_Enabled exception
864: --
865: if p_validate then

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

872: p_effective_start_date := l_effective_start_date;
873: p_effective_end_date := l_effective_end_date;
874: p_object_version_number := l_object_version_number;
875: --
876: hr_utility.set_location(' Leaving:'||l_proc, 70);
877: --
878: exception
879: --
880: when hr_api.validate_enabled then

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

891: p_prtt_prem_id := null;
892: p_effective_start_date := null;
893: p_effective_end_date := null;
894: p_object_version_number := null;
895: hr_utility.set_location(' Leaving:'||l_proc, 80);
896: --
897: when others then
898: --
899: -- A validation or unexpected error has occured

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

965: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
966: --
967: begin
968: --
969: hr_utility.set_location('Entering:'|| l_proc, 10);
970: --
971: -- Issue a savepoint if operating in validation only mode
972: --
973: savepoint update_PRTT_PREM;

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

971: -- Issue a savepoint if operating in validation only mode
972: --
973: savepoint update_PRTT_PREM;
974: --
975: hr_utility.set_location(l_proc, 20);
976: --
977: -- Process Logic
978: --
979: l_object_version_number := p_object_version_number;

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

1156: -- End of API User Hook for the after hook of update_PRTT_PREM
1157: --
1158: end;
1159: --
1160: hr_utility.set_location(l_proc, 60);
1161: --
1162: -- When in validation only mode raise the Validate_Enabled exception
1163: --
1164: if p_validate then

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

1170: p_object_version_number := l_object_version_number;
1171: p_effective_start_date := l_effective_start_date;
1172: p_effective_end_date := l_effective_end_date;
1173: --
1174: hr_utility.set_location(' Leaving:'||l_proc, 70);
1175: --
1176: exception
1177: --
1178: when hr_api.validate_enabled then

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

1185: -- Only set output warning arguments
1186: -- (Any key or derived arguments must be set to null
1187: -- when validation only mode is being used.)
1188: --
1189: hr_utility.set_location(' Leaving:'||l_proc, 80);
1190: --
1191: when others then
1192: --
1193: -- A validation or unexpected error has occured

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

1268: pen.effective_start_date and pen.effective_end_date;
1269: --
1270: begin
1271: --
1272: hr_utility.set_location('Entering:'|| l_proc, 10);
1273: --
1274: -- Issue a savepoint if operating in validation only mode
1275: --
1276: savepoint update_PRTT_PREM;

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

1281: l_per_in_ler_id:=hr_api.g_number;
1282: end if;
1283: close c_per_in_ler;
1284: --
1285: hr_utility.set_location(l_proc, 20);
1286: --
1287: -- Process Logic
1288: --
1289: l_object_version_number := p_object_version_number;

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

1466: -- End of API User Hook for the after hook of update_PRTT_PREM
1467: --
1468: end;
1469: --
1470: hr_utility.set_location(l_proc, 60);
1471: --
1472: -- When in validation only mode raise the Validate_Enabled exception
1473: --
1474: if p_validate then

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

1480: p_object_version_number := l_object_version_number;
1481: p_effective_start_date := l_effective_start_date;
1482: p_effective_end_date := l_effective_end_date;
1483: --
1484: hr_utility.set_location(' Leaving:'||l_proc, 70);
1485: --
1486: exception
1487: --
1488: when hr_api.validate_enabled then

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

1495: -- Only set output warning arguments
1496: -- (Any key or derived arguments must be set to null
1497: -- when validation only mode is being used.)
1498: --
1499: hr_utility.set_location(' Leaving:'||l_proc, 80);
1500: --
1501: when others then
1502: --
1503: -- A validation or unexpected error has occured

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

1528: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1529: --
1530: begin
1531: --
1532: hr_utility.set_location('Entering:'|| l_proc, 10);
1533: --
1534: -- Issue a savepoint if operating in validation only mode
1535: --
1536: savepoint delete_PRTT_PREM;

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

1534: -- Issue a savepoint if operating in validation only mode
1535: --
1536: savepoint delete_PRTT_PREM;
1537: --
1538: hr_utility.set_location(l_proc, 20);
1539: --
1540: -- Process Logic
1541: --
1542: l_object_version_number := p_object_version_number;

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

1597: -- End of API User Hook for the after hook of delete_PRTT_PREM
1598: --
1599: end;
1600: --
1601: hr_utility.set_location(l_proc, 60);
1602: --
1603: -- When in validation only mode raise the Validate_Enabled exception
1604: --
1605: if p_validate then

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

1605: if p_validate then
1606: raise hr_api.validate_enabled;
1607: end if;
1608: --
1609: hr_utility.set_location(' Leaving:'||l_proc, 70);
1610: --
1611: exception
1612: --
1613: when hr_api.validate_enabled then

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

1655: l_validation_end_date date;
1656: --
1657: begin
1658: --
1659: hr_utility.set_location('Entering:'|| l_proc, 10);
1660: --
1661: ben_ppe_shd.lck
1662: (
1663: p_prtt_prem_id => p_prtt_prem_id

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

1667: ,p_effective_date => p_effective_date
1668: ,p_datetrack_mode => p_datetrack_mode
1669: );
1670: --
1671: hr_utility.set_location(' Leaving:'||l_proc, 70);
1672: --
1673: end lck;
1674: --
1675: end ben_PRTT_PREM_api;