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_GROUPS_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_GROUPS_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: cursor csr_grps(v_group_per_in_ler_id number
10: ,v_group_pl_id number
11: ,v_group_oipl_id number) is

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

63: --
64: l_proc varchar2(72) := g_package||'create_group_budget';
65: begin
66: if g_debug then
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68: end if;
69: --
70: -- Issue a savepoint
71: --

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

222: --
223: p_object_version_number := l_object_version_number;
224: --
225: if g_debug then
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: end if;
228: exception
229: when hr_api.validate_enabled then
230: --

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

233: --
234: rollback to create_group_budget;
235: --
236: if g_debug then
237: hr_utility.set_location(' Leaving:'||l_proc, 80);
238: end if;
239: when others then
240: --
241: -- A validation or unexpected error has occured

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

242: --
243: rollback to create_group_budget;
244: --
245: if g_debug then
246: hr_utility.set_location(' Leaving:'||l_proc, 90);
247: end if;
248: raise;
249: end create_group_budget;
250: --

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

266: --
267: Begin
268: --
269: if g_debug then
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);

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

267: Begin
268: --
269: if g_debug then
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);

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

268: --
269: if g_debug then
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);
276: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);

Line 273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);

269: if g_debug then
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);
276: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
277: end if;

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

270: hr_utility.set_location('Entering:'||l_proc, 10);
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);
276: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
277: end if;
278: --

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

271: hr_utility.set_location('Entering:'||l_proc, 10);
272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);
276: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
277: end if;
278: --
279: select full_name into l_person_name

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

272: hr_utility.set_location('p_val :'||p_val, 10);
273: hr_utility.set_location('p_iss_val :'||p_iss_val,10);
274: hr_utility.set_location('p_min_val :'||p_min_val, 10);
275: hr_utility.set_location('p_max_val :'||p_max_val, 10);
276: hr_utility.set_location('p_incr_val :'||p_incr_val, 10);
277: end if;
278: --
279: select full_name into l_person_name
280: from ben_cwb_person_info

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

281: where group_per_in_ler_id = p_group_per_in_ler_id;
282: --
283: --
284: if g_debug then
285: hr_utility.set_location(l_proc, 20);
286: end if;
287: --
288: if (p_val is not null and p_val <> hr_api.g_number and
289: p_min_val is not null) then

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

297: end if;
298: end if;
299: --
300: if g_debug then
301: hr_utility.set_location(l_proc, 30);
302: end if;
303: --
304: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
305: p_min_val is not null) then

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

313: end if;
314: end if;
315: --
316: if g_debug then
317: hr_utility.set_location(l_proc, 40);
318: end if;
319: --
320: if (p_val is not null and p_val <> hr_api.g_number and
321: p_max_val is not null) then

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

329: end if;
330: end if;
331: --
332: if g_debug then
333: hr_utility.set_location(l_proc, 50);
334: end if;
335: --
336: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
337: p_max_val is not null) then

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

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

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

359: fnd_message.raise_error;
360: end if;
361: end if;
362: if g_debug then
363: hr_utility.set_location(l_proc, 70);
364: end if;
365: --
366: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
367: p_incr_val is not null) then

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

374: end if;
375: end if;
376: --
377: if g_debug then
378: hr_utility.set_location(' Leaving:'||l_proc, 90);
379: end if;
380: end check_min_max;
381: --
382: -- --------------------------------------------------------------------------

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

422: --
423: begin
424: --
425: if g_debug then
426: hr_utility.set_location('Entering:'|| l_proc, 10);
427: end if;
428: --
429: select uses_bdgt_flag, prsrv_bdgt_cd
430: into l_uses_bdgt_flag, l_prsrv_bdgt_cd

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

459: l_ws_bdgt_iss_val := p_ws_bdgt_iss_val;
460: end if;
461: --
462: if g_debug then
463: hr_utility.set_location(l_proc, 20);
464: end if;
465: --
466: if nvl(p_grp_bdgt_old.dist_bdgt_val,0) <> nvl(l_dist_bdgt_val,0) or
467: nvl(p_grp_bdgt_old.ws_bdgt_val,0) <> nvl(l_ws_bdgt_val,0) or

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

469: nvl(p_grp_bdgt_old.ws_bdgt_iss_val,0) <> nvl(l_ws_bdgt_iss_val,0) then
470: --
471: --
472: if g_debug then
473: hr_utility.set_location(l_proc, 30);
474: end if;
475: --
476: if l_prsrv_bdgt_cd = 'A' then
477: --

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

475: --
476: if l_prsrv_bdgt_cd = 'A' then
477: --
478: if g_debug then
479: hr_utility.set_location(l_proc, 40);
480: end if;
481: --
482: l_diff_dist_bdgt := ben_cwb_utils.add_number_with_null_check
483: (l_dist_bdgt_val,

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

494: --
495: else
496: --
497: if g_debug then
498: hr_utility.set_location(l_proc, 50);
499: end if;
500: --
501: select sum(elig_sal_val_direct) elig_sal_val_direct
502: ,sum(elig_sal_val_all) elig_sal_val_all

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

530: l_diff_dist_bdgt_iss := l_diff_ws_bdgt_iss;
531: end if;
532: --
533: if g_debug then
534: hr_utility.set_location(l_proc, 60);
535: end if;
536: --
537: -- The first one will be the immediate manager
538: l_immediate_mgr := 1;

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

539: for mgr in csr_mgr_pil_ids(p_grp_bdgt_old.group_per_in_ler_id)
540: loop
541: --
542: if g_debug then
543: hr_utility.set_location(l_proc, 70);
544: end if;
545: --
546: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
547: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id

Line 562: hr_utility.set_location(' Leaving:'|| l_proc, 999);

558: end loop;
559: end if; -- of difference in ws or db budget values
560: --
561: if g_debug then
562: hr_utility.set_location(' Leaving:'|| l_proc, 999);
563: end if;
564: --
565: end; -- update_group_budget_summary
566: --

Line 590: hr_utility.set_location('Entering :'|| l_proc, 100);

586:
587: begin
588:
589: if g_debug then
590: hr_utility.set_location('Entering :'|| l_proc, 100);
591: end if;
592:
593: open csr_grps(p_grp_bdgt_old.group_per_in_ler_id
594: ,p_grp_bdgt_old.group_pl_id

Line 620: hr_utility.set_location('Entering BAD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 101);

616: if(l_pl_dsgn.prsrv_bdgt_cd='A') then
617: if(ben_cwb_audit_api.return_lookup_validity('BAD')=true) then
618:
619: if g_debug then
620: hr_utility.set_location('Entering BAD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 101);
621: end if;
622:
623: ben_cwb_audit_api.create_audit_entry
624: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 641: hr_utility.set_location('Entering BPD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 102);

637: end if;
638: elsif(l_pl_dsgn.prsrv_bdgt_cd='P') then
639: if(ben_cwb_audit_api.return_lookup_validity('BPD')=true) then
640: if g_debug then
641: hr_utility.set_location('Entering BPD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 102);
642: end if;
643:
644: ben_cwb_audit_api.create_audit_entry
645: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 671: hr_utility.set_location('Entering BAA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 103);

667: --if(nvl(p_grp_bdgt_old.dist_bdgt_val,-1)<>nvl(l_grp_bdgt_new.dist_bdgt_val,-1)) then
668: if(l_pl_dsgn.prsrv_bdgt_cd='A') then
669: if(ben_cwb_audit_api.return_lookup_validity('BAA')=true) then
670: if g_debug then
671: hr_utility.set_location('Entering BAA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 103);
672: end if;
673:
674: ben_cwb_audit_api.create_audit_entry
675: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 692: hr_utility.set_location('Entering BPA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 104);

688: end if;
689: elsif(l_pl_dsgn.prsrv_bdgt_cd='P') then
690: if(ben_cwb_audit_api.return_lookup_validity('BPA')=true) then
691: if g_debug then
692: hr_utility.set_location('Entering BPA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 104);
693: end if;
694:
695: ben_cwb_audit_api.create_audit_entry
696: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 722: hr_utility.set_location('Entering BP:'||l_proc||p_grp_bdgt_old.bdgt_pop_cd||' '||l_grp_bdgt_new.bdgt_pop_cd, 105);

718: -- if(nvl(p_grp_bdgt_old.bdgt_pop_cd,-1)<>nvl(l_grp_bdgt_new.bdgt_pop_cd,-1)) then
719: if(ben_cwb_audit_api.return_lookup_validity('BP')=true) then
720:
721: if g_debug then
722: hr_utility.set_location('Entering BP:'||l_proc||p_grp_bdgt_old.bdgt_pop_cd||' '||l_grp_bdgt_new.bdgt_pop_cd, 105);
723: end if;
724:
725: ben_cwb_audit_api.create_audit_entry
726: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 749: hr_utility.set_location('Entering DD:'||l_proc||p_grp_bdgt_old.due_dt||' '||l_grp_bdgt_new.due_dt, 106);

745: or (p_grp_bdgt_old.due_dt <> l_grp_bdgt_new.due_dt) ) then
746: if(ben_cwb_audit_api.return_lookup_validity('DD')=true) then
747:
748: if g_debug then
749: hr_utility.set_location('Entering DD:'||l_proc||p_grp_bdgt_old.due_dt||' '||l_grp_bdgt_new.due_dt, 106);
750: end if;
751:
752: ben_cwb_audit_api.create_audit_entry
753: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 776: hr_utility.set_location('Entering SD: '||l_proc||p_grp_bdgt_old.submit_date||' '||l_grp_bdgt_new.submit_date, 107);

772: or (p_grp_bdgt_old.submit_date <> l_grp_bdgt_new.submit_date) ) then
773: if(ben_cwb_audit_api.return_lookup_validity('SD')=true) then
774:
775: if g_debug then
776: hr_utility.set_location('Entering SD: '||l_proc||p_grp_bdgt_old.submit_date||' '||l_grp_bdgt_new.submit_date, 107);
777: end if;
778:
779: ben_cwb_audit_api.create_audit_entry
780: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 823: hr_utility.set_location('Entering BAD:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 108);

819: l_cd_meaning_new:=null;
820: end;
821:
822: if g_debug then
823: hr_utility.set_location('Entering BAD:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 108);
824: end if;
825:
826: ben_cwb_audit_api.create_audit_entry
827: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 871: hr_utility.set_location('Entering AS:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 109);

867: l_cd_meaning_new:=null;
868: end;
869:
870: if g_debug then
871: hr_utility.set_location('Entering AS:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 109);
872: end if;
873:
874: ben_cwb_audit_api.create_audit_entry
875: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 897: hr_utility.set_location('Entering AD:'||l_proc||p_grp_bdgt_old.approval_date||' '||l_grp_bdgt_new.approval_date, 110);

893: and (p_grp_bdgt_old.approval_date is not null))
894: or (p_grp_bdgt_old.approval_date <> l_grp_bdgt_new.approval_date) ) then
895: if(ben_cwb_audit_api.return_lookup_validity('AD')=true) then
896: if g_debug then
897: hr_utility.set_location('Entering AD:'||l_proc||p_grp_bdgt_old.approval_date||' '||l_grp_bdgt_new.approval_date, 110);
898: end if;
899:
900: ben_cwb_audit_api.create_audit_entry
901: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 924: hr_utility.set_location('Entering RS:'||l_proc||p_grp_bdgt_old.rsrv_val||' '||l_grp_bdgt_new.rsrv_val, 111);

920: or (p_grp_bdgt_old.rsrv_val <> l_grp_bdgt_new.rsrv_val) ) then
921: if(ben_cwb_audit_api.return_lookup_validity('RS')=true) then
922:
923: if g_debug then
924: hr_utility.set_location('Entering RS:'||l_proc||p_grp_bdgt_old.rsrv_val||' '||l_grp_bdgt_new.rsrv_val, 111);
925: end if;
926:
927: ben_cwb_audit_api.create_audit_entry
928: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id

Line 971: hr_utility.set_location('Entering AC:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 112);

967: l_cd_meaning_new:= l_grp_bdgt_new.access_cd;
968: end;
969:
970: if g_debug then
971: hr_utility.set_location('Entering AC:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 112);
972: end if;
973:
974:
975: ben_cwb_audit_api.create_audit_entry

Line 992: hr_utility.set_location('Exiting person groups '|| l_proc, 200);

988: );
989: end if;
990: end if;
991: if g_debug then
992: hr_utility.set_location('Exiting person groups '|| l_proc, 200);
993: end if;
994:
995: end create_audit_record;
996: --

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

1064: --
1065: l_proc varchar2(72) := g_package||'update_group_budget';
1066: begin
1067: if g_debug then
1068: hr_utility.set_location('Entering:'|| l_proc, 10);
1069: end if;
1070: --
1071: -- Issue a savepoint
1072: --

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

1159: end if;
1160: --
1161: --
1162: if g_debug then
1163: hr_utility.set_location(l_proc, 30);
1164: end if;
1165: --
1166: if (p_ws_bdgt_mx_val is null or
1167: p_ws_bdgt_mx_val <> hr_api.g_number) then

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

1178: l_mn_mx_vals.ws_bdgt_incr_val := p_ws_bdgt_incr_val;
1179: end if;
1180: --
1181: if g_debug then
1182: hr_utility.set_location(l_proc, 50);
1183: end if;
1184: --
1185: -- Check Min, Max and Inc for Dist Bdgt Val
1186: --

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

1191: ,p_incr_val => l_mn_mx_vals.dist_bdgt_incr_val
1192: ,p_group_per_in_ler_id => p_group_per_in_ler_id);
1193: --
1194: if g_debug then
1195: hr_utility.set_location(l_proc, 60);
1196: end if;
1197: --
1198: --
1199: -- Check Min, Max and Inc for Ws Bdgt Val

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

1205: ,p_incr_val => l_mn_mx_vals.ws_bdgt_incr_val
1206: ,p_group_per_in_ler_id => p_group_per_in_ler_id);
1207: --
1208: if g_debug then
1209: hr_utility.set_location(l_proc, 70);
1210: end if;
1211: --
1212: end if; -- of p_perf_min_max_edit
1213: --

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

1357: --
1358: p_object_version_number := l_object_version_number;
1359: --
1360: if g_debug then
1361: hr_utility.set_location(' Leaving:'||l_proc, 80);
1362: end if;
1363: exception
1364: when hr_api.validate_enabled then
1365: --

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

1372: -- (Any key or derived arguments must be set to null
1373: -- when validation only mode is being used.)
1374: --
1375: if g_debug then
1376: hr_utility.set_location(' Leaving:'||l_proc, 90);
1377: end if;
1378: when others then
1379: --
1380: -- A validation or unexpected error has occured

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

1384: -- Reset IN OUT parameters and set all
1385: -- OUT parameters, including warnings, to null
1386: --
1387: if g_debug then
1388: hr_utility.set_location(' Leaving:'||l_proc, 99);
1389: end if;
1390: raise;
1391: end update_group_budget;
1392: --

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

1410: l_proc varchar2(72) := g_package||'delete_group_budget';
1411: l_grp_bdgt_old csr_grps%rowtype;
1412: begin
1413: if g_debug then
1414: hr_utility.set_location('Entering:'|| l_proc, 10);
1415: end if;
1416: --
1417: -- Issue a savepoint
1418: --

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

1493: ,p_ws_bdgt_iss_val => null);
1494: end if;
1495: --
1496: if g_debug then
1497: hr_utility.set_location(' Leaving:'||l_proc, 70);
1498: end if;
1499: exception
1500: when hr_api.validate_enabled then
1501: --

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

1504: --
1505: rollback to delete_group_budget;
1506: --
1507: if g_debug then
1508: hr_utility.set_location(' Leaving:'||l_proc, 80);
1509: end if;
1510: when others then
1511: --
1512: -- A validation or unexpected error has occured

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

1516: -- Reset IN OUT parameters and set all
1517: -- OUT parameters, including warnings, to null
1518: --
1519: if g_debug then
1520: hr_utility.set_location(' Leaving:'||l_proc, 90);
1521: end if;
1522: raise;
1523: end delete_group_budget;
1524: --