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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PERSON_RATES_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: cursor csr_rates(v_group_per_in_ler_id number
9: ,v_pl_id number
10: ,v_oipl_id number) is
11: select *

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

82: --
83: l_proc varchar2(72) := g_package||'create_person_rate';
84: begin
85: if g_debug then
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: end if;
88: --
89: -- Issue a savepoint
90: --

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

290: p_person_rate_id := l_person_rate_id;
291: p_object_version_number := l_object_version_number;
292: --
293: if g_debug then
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: end if;
296: exception
297: when hr_api.validate_enabled then
298: --

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

301: --
302: rollback to create_person_rate;
303: --
304: if g_debug then
305: hr_utility.set_location(' Leaving:'||l_proc, 80);
306: end if;
307: when others then
308: --
309: -- A validation or unexpected error has occured

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

310: --
311: rollback to create_person_rate;
312: --
313: if g_debug then
314: hr_utility.set_location(' Leaving:'||l_proc, 90);
315: end if;
316: raise;
317: end create_person_rate;
318: --

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

332: --
333: Begin
334: --
335: if g_debug then
336: hr_utility.set_location('Entering:'||l_proc, 10);
337: hr_utility.set_location('p_val :'||p_val, 10);
338: hr_utility.set_location('p_min_val :'||p_min_val, 10);
339: hr_utility.set_location('p_max_val :'||p_max_val, 10);
340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);

Line 337: hr_utility.set_location('p_val :'||p_val, 10);

333: Begin
334: --
335: if g_debug then
336: hr_utility.set_location('Entering:'||l_proc, 10);
337: hr_utility.set_location('p_val :'||p_val, 10);
338: hr_utility.set_location('p_min_val :'||p_min_val, 10);
339: hr_utility.set_location('p_max_val :'||p_max_val, 10);
340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
341: end if;

Line 338: hr_utility.set_location('p_min_val :'||p_min_val, 10);

334: --
335: if g_debug then
336: hr_utility.set_location('Entering:'||l_proc, 10);
337: hr_utility.set_location('p_val :'||p_val, 10);
338: hr_utility.set_location('p_min_val :'||p_min_val, 10);
339: hr_utility.set_location('p_max_val :'||p_max_val, 10);
340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
341: end if;
342: --

Line 339: hr_utility.set_location('p_max_val :'||p_max_val, 10);

335: if g_debug then
336: hr_utility.set_location('Entering:'||l_proc, 10);
337: hr_utility.set_location('p_val :'||p_val, 10);
338: hr_utility.set_location('p_min_val :'||p_min_val, 10);
339: hr_utility.set_location('p_max_val :'||p_max_val, 10);
340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
341: end if;
342: --
343: select full_name into l_person_name

Line 340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);

336: hr_utility.set_location('Entering:'||l_proc, 10);
337: hr_utility.set_location('p_val :'||p_val, 10);
338: hr_utility.set_location('p_min_val :'||p_min_val, 10);
339: hr_utility.set_location('p_max_val :'||p_max_val, 10);
340: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
341: end if;
342: --
343: select full_name into l_person_name
344: from ben_cwb_person_info

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

345: where group_per_in_ler_id = p_group_per_in_ler_id;
346: --
347: --
348: if g_debug then
349: hr_utility.set_location(l_proc, 20);
350: end if;
351: --
352: if (p_val is not null and p_val <> hr_api.g_number and
353: p_min_val is not null) then

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

362: end if;
363: --
364: --
365: if g_debug then
366: hr_utility.set_location(l_proc, 30);
367: end if;
368: --
369: if (p_val is not null and p_val <> hr_api.g_number and
370: p_max_val is not null) then

Line 382: hr_utility.set_location(l_proc, 40);

378: end if;
379: end if;
380: --
381: if g_debug then
382: hr_utility.set_location(l_proc, 40);
383: end if;
384: --
385: if (p_val is not null and p_val <> hr_api.g_number and
386: p_incr_val is not null) then

Line 396: hr_utility.set_location(l_proc, 70);

392: fnd_message.raise_error;
393: end if;
394: end if;
395: if g_debug then
396: hr_utility.set_location(l_proc, 70);
397: end if;
398: --
399: if g_debug then
400: hr_utility.set_location(' Leaving:'||l_proc, 90);

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

396: hr_utility.set_location(l_proc, 70);
397: end if;
398: --
399: if g_debug then
400: hr_utility.set_location(' Leaving:'||l_proc, 90);
401: end if;
402: end check_min_max;
403: --
404: --

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

463: --
464: l_proc varchar2(72) :=g_package||'update_person_rates_summary';
465: begin
466: if g_debug then
467: hr_utility.set_location('Entering:'|| l_proc, 10);
468: end if;
469: -- get the pl_xchg_rate and nnmntry_uom from pl_dsgn
470: open csr_xchg_rt(p_rates_new.pl_id
471: ,p_rates_new.oipl_id

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

485: l_old_xchg_rt := l_new_xchg_rt;
486: end if;
487: --
488: if g_debug then
489: hr_utility.set_location(l_proc, 30);
490: end if;
491: --
492: -- check if the eligibility is changed
493: if nvl(p_rates_new.elig_flag,'N') <> nvl(p_rates_old.elig_flag,'N') then

Line 496: hr_utility.set_location(l_proc, 40);

492: -- check if the eligibility is changed
493: if nvl(p_rates_new.elig_flag,'N') <> nvl(p_rates_old.elig_flag,'N') then
494: -- there is a change in eligibility.
495: if g_debug then
496: hr_utility.set_location(l_proc, 40);
497: end if;
498: if nvl(p_rates_new.elig_flag,'N') = 'Y' then
499: -- the person has become eligible
500: l_elig_count_d :=1;

Line 529: hr_utility.set_location(l_proc, 50);

525: ,p_elig_sal_change => l_elig_sal_val_d);
526: end if;
527: else
528: if g_debug then
529: hr_utility.set_location(l_proc, 50);
530: end if;
531: -- the person has become in-eligible
532: l_elig_count_d := -1;
533: if(nvl(p_rates_old.ws_val,0)<>0) then

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

558: end if;
559: end if; -- of elig_flg = 'Y'
560: else
561: if g_debug then
562: hr_utility.set_location(l_proc, 60);
563: end if;
564: -- there is no change in the eligibiltiy.
565: if nvl(p_rates_new.elig_flag,'N') = 'N' then
566: -- The emp remains in-eligible. So no change in summary

Line 622: hr_utility.set_location(l_proc, 70);

618: ,p_elig_sal_change => l_elig_sal_val_d);
619: end if;
620: end if; -- of check comare elig flags.
621: if g_debug then
622: hr_utility.set_location(l_proc, 70);
623: end if;
624: --
625: -- Check the differences
626: if (l_elig_count_d <> 0 or l_emp_recv_count_d <> 0 or l_ws_val_d <> 0 or

Line 633: hr_utility.set_location(l_proc, 80);

629: l_misc3_val_d <> 0 or l_rec_val_d <> 0 or l_rec_mn_val_d <> 0 or
630: l_rec_mx_val_d <> 0 ) then
631: --
632: if g_debug then
633: hr_utility.set_location(l_proc, 80);
634: end if;
635: --There is a change in the record
636: l_immd_mgr := 1;
637: for mgr in csr_mgr_pil_ids(p_rates_new.group_per_in_ler_id)

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

683: ben_cwb_summary_pkg.save_pl_sql_tab;
684: end if;
685: --
686: if g_debug then
687: hr_utility.set_location(' Leaving:'|| l_proc, 99);
688: end if;
689: --
690: end; -- update_rates_summary
691: --

Line 732: hr_utility.set_location('entering:'|| g_package, 203);

728:
729: begin
730:
731: if g_debug then
732: hr_utility.set_location('entering:'|| g_package, 203);
733: end if;
734:
735: open csr_rates(p_rates_old.group_per_in_ler_id,
736: p_rates_old.pl_id,

Line 746: hr_utility.set_location('person_id:'|| l_person_id, 23);

742: from fnd_user
743: where user_id = l_rates_new.last_updated_by;
744:
745: if g_debug then
746: hr_utility.set_location('person_id:'|| l_person_id, 23);
747: end if;
748: if g_debug then
749: hr_utility.set_location('user_id:'|| l_rates_new.last_updated_by, 24);
750: end if;

Line 749: hr_utility.set_location('user_id:'|| l_rates_new.last_updated_by, 24);

745: if g_debug then
746: hr_utility.set_location('person_id:'|| l_person_id, 23);
747: end if;
748: if g_debug then
749: hr_utility.set_location('user_id:'|| l_rates_new.last_updated_by, 24);
750: end if;
751:
752:
753: if( ((p_rates_old.ws_val is null)

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

1214: --
1215: l_proc varchar2(72) := g_package||'update_person_rate';
1216: begin
1217: if g_debug then
1218: hr_utility.set_location('Entering:'|| l_proc, 10);
1219: end if;
1220: --
1221: -- Issue a savepoint
1222: --

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

1327: end if;
1328: --
1329: --
1330: if g_debug then
1331: hr_utility.set_location(l_proc, 30);
1332: end if;
1333: --
1334: if (p_rec_mx_val is null) then
1335: l_mn_mx_vals.rec_mx_val := null;

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

1352: l_mn_mx_vals.rec_incr_val := p_rec_incr_val;
1353: end if;
1354: --
1355: if g_debug then
1356: hr_utility.set_location(l_proc, 40);
1357: end if;
1358: --
1359: -- Check Min, Max and Inc for Ws Val
1360: --

Line 1368: hr_utility.set_location(l_proc, 50);

1364: ,p_incr_val => l_mn_mx_vals.ws_incr_val
1365: ,p_group_per_in_ler_id => p_group_per_in_ler_id);
1366: --
1367: if g_debug then
1368: hr_utility.set_location(l_proc, 50);
1369: end if;
1370: --
1371: --
1372: -- Check Min, Max and Inc for Rec Val

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

1377: ,p_incr_val => l_mn_mx_vals.rec_incr_val
1378: ,p_group_per_in_ler_id => p_group_per_in_ler_id);
1379: --
1380: if g_debug then
1381: hr_utility.set_location(l_proc, 60);
1382: end if;
1383: --
1384: end if; -- of p_perf_min_max_edit
1385: --

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

1524: --
1525: p_object_version_number := l_object_version_number;
1526: --
1527: if g_debug then
1528: hr_utility.set_location(' Leaving:'||l_proc, 70);
1529: end if;
1530: exception
1531: when hr_api.validate_enabled then
1532: --

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

1535: --
1536: rollback to update_person_rate;
1537: --
1538: if g_debug then
1539: hr_utility.set_location(' Leaving:'||l_proc, 80);
1540: end if;
1541: when others then
1542: --
1543: -- A validation or unexpected error has occured

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

1544: --
1545: rollback to update_person_rate;
1546: --
1547: if g_debug then
1548: hr_utility.set_location(' Leaving:'||l_proc, 90);
1549: end if;
1550: raise;
1551: end update_person_rate;
1552: --

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

1569: l_rates_new csr_rates%rowtype;
1570: --
1571: begin
1572: if g_debug then
1573: hr_utility.set_location('Entering:'|| l_proc, 10);
1574: end if;
1575: --
1576: -- Issue a savepoint
1577: --

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

1646: update_rates_summary(l_rates_old,l_rates_new);
1647: end if;
1648: --
1649: if g_debug then
1650: hr_utility.set_location(' Leaving:'||l_proc, 70);
1651: end if;
1652: exception
1653: when hr_api.validate_enabled then
1654: --

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

1657: --
1658: rollback to delete_person_rate;
1659: --
1660: if g_debug then
1661: hr_utility.set_location(' Leaving:'||l_proc, 80);
1662: end if;
1663: when others then
1664: --
1665: -- A validation or unexpected error has occured

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

1669: -- Reset IN OUT parameters and set all
1670: -- OUT parameters, including warnings, to null
1671: --
1672: if g_debug then
1673: hr_utility.set_location(' Leaving:'||l_proc, 90);
1674: end if;
1675: raise;
1676: end delete_person_rate;
1677: --