DBA Data[Home] [Help]

APPS.BEN_COMP_OBJ_FILTER dependencies on HR_UTILITY

Line 31: -- hr_utility.set_location ('Entering ' || l_package,10);

27: l_hv pls_integer;
28: --
29: begin
30: --
31: -- hr_utility.set_location ('Entering ' || l_package,10);
32: --
33: -- Get the hashed value for the ptip
34: --
35: l_hv := mod(p_ptip_id,g_hash_key);

Line 61: -- hr_utility.set_location ('Leaving '||l_package,10);

57: end loop;
58: --
59: end if;
60: --
61: -- hr_utility.set_location ('Leaving '||l_package,10);
62: --
63: exception when NO_DATA_FOUND then
64: --
65: -- No value stored for the hashed value due to the error being raised.

Line 105: hr_utility.set_location ('Entering ' || l_package,10);

101: l_hv pls_integer;
102: --
103: begin
104: --
105: hr_utility.set_location ('Entering ' || l_package,10);
106: --
107: -- Get the hashed value for the ptip
108: --
109: l_hv := ben_hash_utility.get_hashed_index(p_id => p_ptip_id);

Line 137: hr_utility.set_location ('Leaving '||l_package,10);

133: g_procptip_list(l_hv).eligible := p_eligible;
134: --
135: end if;
136: --
137: hr_utility.set_location ('Leaving '||l_package,10);
138: --
139: exception when NO_DATA_FOUND then
140: --
141: -- No value stored for the hashed value due to the error being raised.

Line 144: hr_Utility.set_location('hit no_data_found condition',10);

140: --
141: -- No value stored for the hashed value due to the error being raised.
142: -- We are dealing with a unique PTIP. Add the PTIP to the list
143: --
144: hr_Utility.set_location('hit no_data_found condition',10);
145: g_procptip_list(l_hv).ptip_id := p_ptip_id;
146: --
147: -- Initialise the ptip eligible flag to false this will be set at
148: -- the end of eligibility to the determined eligibility result.

Line 168: hr_utility.set_location ('Entering ' || l_package,10);

164: l_hv pls_integer;
165: --
166: begin
167: --
168: hr_utility.set_location ('Entering ' || l_package,10);
169: --
170: -- Get the hashed value for the ptip
171: --
172: l_hv := ben_hash_utility.get_hashed_index(p_id => p_ptip_id);

Line 200: hr_utility.set_location ('Leaving '||l_package,10);

196: return g_procptip_list(l_hv).eligible;
197: --
198: end if;
199: --
200: hr_utility.set_location ('Leaving '||l_package,10);
201: --
202: exception when NO_DATA_FOUND then
203: --
204: -- No value stored for the hashed value due to the error being raised.

Line 207: hr_Utility.set_location('hit no_data_found condition',20);

203: --
204: -- No value stored for the hashed value due to the error being raised.
205: -- We are dealing with a unique PTIP. Add the PTIP to the list
206: --
207: hr_Utility.set_location('hit no_data_found condition',20);
208: g_procptip_list(l_hv).ptip_id := p_ptip_id;
209: --
210: -- Initialise the ptip eligible flag to false this will be set at
211: -- the end of eligibility to the determined eligibility result.

Line 234: -- hr_utility.set_location ('Entering ' || l_package,10);

230: l_hv pls_integer;
231: --
232: begin
233: --
234: -- hr_utility.set_location ('Entering ' || l_package,10);
235: --
236: if p_eligible then
237: --
238: if p_comp_obj_tree_row.pgm_id is not null then

Line 307: -- hr_utility.set_location ('Leaving '||l_package,10);

303: end if;
304: --
305: end if;
306: --
307: -- hr_utility.set_location ('Leaving '||l_package,10);
308: --
309: end set_parent_elig_flags;
310: --
311: procedure set_bound_parent_elig_flags

Line 322: -- hr_utility.set_location ('Entering ' || l_package,10);

318: l_package varchar2(80) := g_package||'.set_bound_parent_elig_flags';
319: --
320: begin
321: --
322: -- hr_utility.set_location ('Entering ' || l_package,10);
323: --
324: if p_comp_obj_tree_row.pl_id is not null
325: and p_comp_obj_tree_row.pl_nip = 'N'
326: then

Line 346: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||p_comp_obj_tree_row.ptip_id,20);

342: p_par_elig_state.elig_for_pl_flag := 'Y';
343: --
344: elsif p_comp_obj_tree_row.ptip_id is not null then
345: --
346: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||p_comp_obj_tree_row.ptip_id,20);
347: --
348: p_par_elig_state.elig_for_ptip_flag := 'Y';
349: p_par_elig_state.elig_for_plip_flag := 'Y';
350: p_par_elig_state.elig_for_pl_flag := 'Y';

Line 354: hr_utility.set_location ('BENMGLEINPEFPGM: '||p_comp_obj_tree_row.pgm_id,20);

350: p_par_elig_state.elig_for_pl_flag := 'Y';
351: --
352: elsif p_comp_obj_tree_row.pgm_id is not null then
353: --
354: hr_utility.set_location ('BENMGLEINPEFPGM: '||p_comp_obj_tree_row.pgm_id,20);
355: --
356: p_par_elig_state.elig_for_pgm_flag := 'Y';
357: p_par_elig_state.elig_for_ptip_flag := 'Y';
358: p_par_elig_state.elig_for_plip_flag := 'Y';

Line 363: -- hr_utility.set_location ('Leaving '||l_package,10);

359: p_par_elig_state.elig_for_pl_flag := 'Y';
360: --
361: end if;
362: --
363: -- hr_utility.set_location ('Leaving '||l_package,10);
364: --
365: end set_bound_parent_elig_flags;
366: --
367: function check_prevelig_compobj

Line 393: -- hr_utility.set_location ('PTIP PILPEP ' || l_package,10);

389: l_prevelig := false;
390: --
391: elsif p_comp_obj_tree_row.ptip_id is not null then
392: --
393: -- hr_utility.set_location ('PTIP PILPEP ' || l_package,10);
394: --
395: ben_pep_cache.get_pilpep_dets
396: (p_person_id => p_person_id
397: ,p_business_group_id => p_business_group_id

Line 411: -- hr_utility.set_location ('Dn PTIP PILPEP ' || l_package,10);

407: l_prevelig := TRUE;
408: --
409: end if;
410: --
411: -- hr_utility.set_location ('Dn PTIP PILPEP ' || l_package,10);
412: --
413: elsif p_comp_obj_tree_row.plip_id is not null then
414: --
415: -- hr_utility.set_location ('PLIP PILPEP ' || l_package,10);

Line 415: -- hr_utility.set_location ('PLIP PILPEP ' || l_package,10);

411: -- hr_utility.set_location ('Dn PTIP PILPEP ' || l_package,10);
412: --
413: elsif p_comp_obj_tree_row.plip_id is not null then
414: --
415: -- hr_utility.set_location ('PLIP PILPEP ' || l_package,10);
416: --
417: ben_pep_cache.get_pilpep_dets
418: (p_person_id => p_person_id
419: ,p_business_group_id => p_business_group_id

Line 433: -- hr_utility.set_location ('Dn PLIP PILPEP ' || l_package,10);

429: l_prevelig := TRUE;
430: --
431: end if;
432: --
433: -- hr_utility.set_location ('Dn PLIP PILPEP ' || l_package,10);
434: --
435: elsif p_comp_obj_tree_row.pl_id is not null
436: then
437: --

Line 438: -- hr_utility.set_location ('PL PILPEP ' || l_package,10);

434: --
435: elsif p_comp_obj_tree_row.pl_id is not null
436: then
437: --
438: -- hr_utility.set_location ('PL PILPEP ' || l_package,10);
439: --
440: ben_pep_cache.get_pilpep_dets
441: (p_person_id => p_person_id
442: ,p_business_group_id => p_business_group_id

Line 456: -- hr_utility.set_location ('Dn PL PILPEP ' || l_package,10);

452: l_prevelig := TRUE;
453: --
454: end if;
455: --
456: -- hr_utility.set_location ('Dn PL PILPEP ' || l_package,10);
457: --
458: elsif p_comp_obj_tree_row.oipl_id is not null then
459: --
460: -- hr_utility.set_location ('OIPL PILPEP ' || l_package,10);

Line 460: -- hr_utility.set_location ('OIPL PILPEP ' || l_package,10);

456: -- hr_utility.set_location ('Dn PL PILPEP ' || l_package,10);
457: --
458: elsif p_comp_obj_tree_row.oipl_id is not null then
459: --
460: -- hr_utility.set_location ('OIPL PILPEP ' || l_package,10);
461: --
462: ben_pep_cache.get_pilepo_dets
463: (p_person_id => p_person_id
464: ,p_business_group_id => p_business_group_id

Line 479: -- hr_utility.set_location ('Dn OIPL PILPEP ' || l_package,10);

475: l_prevelig := TRUE;
476: --
477: end if;
478: --
479: -- hr_utility.set_location ('Dn OIPL PILPEP ' || l_package,10);
480: --
481: end if;
482: --
483: return l_prevelig;

Line 669: hr_utility.set_location ('Entering '||l_package,10);

665: order by ordr_to_aply_num;
666: --
667: begin
668: --
669: hr_utility.set_location ('Entering '||l_package,10);
670: --
671: l_par_elig_state := p_par_elig_state;
672: l_treeele_num := p_treeele_num;
673: --

Line 679: hr_utility.set_location ('St CO Tree Loop '||l_package,10);

675: --
676: -- Comp object navigation loop. Only loop if a boundary is hit
677: --
678: loop
679: hr_utility.set_location ('St CO Tree Loop '||l_package,10);
680: --
681: -- Set comp object tree row record
682: --
683: l_comp_obj_tree_row := p_comp_obj_tree(l_treeele_num);

Line 695: hr_utility.set_location ('PGM Chk '||l_package,10);

691: --
692: -- Initialise parent eligibility flags
693: --
694: if l_pgm_id is not null then
695: hr_utility.set_location ('PGM Chk '||l_package,10);
696: --
697: l_failed_rule:=false;
698: -- PB : 5422 : if p_popl_enrt_typ_cycl_id is not null then
699: if p_lf_evt_ocrd_dt is not null then

Line 707: hr_utility.set_location('Rule passed for pgm',15);

703: (p_person_selection_rule_id =>l_person_selection.formula_id,
704: p_person_id =>p_person_id,
705: p_business_group_id =>p_business_group_id,
706: p_effective_date =>p_effective_date) then
707: hr_utility.set_location('Rule passed for pgm',15);
708: else
709: l_failed_rule:=true;
710: exit;
711: end if;

Line 722: hr_utility.set_location('Rule passed for pgm',15);

718: (p_person_selection_rule_id =>l_person_selection.formula_id,
719: p_person_id =>p_person_id,
720: p_business_group_id =>p_business_group_id,
721: p_effective_date =>p_effective_date) then
722: hr_utility.set_location('Rule passed for pgm',15);
723: else
724: hr_utility.set_location('Rule failed for pgm',15);
725: l_failed_rule:=true;
726: exit;

Line 724: hr_utility.set_location('Rule failed for pgm',15);

720: p_business_group_id =>p_business_group_id,
721: p_effective_date =>p_effective_date) then
722: hr_utility.set_location('Rule passed for pgm',15);
723: else
724: hr_utility.set_location('Rule failed for pgm',15);
725: l_failed_rule:=true;
726: exit;
727: end if;
728: end if;

Line 753: hr_utility.set_location ('BENMGLEINPEFPGM: '||l_pgm_id,20);

749: --
750: end if;
751: end loop;
752: else
753: hr_utility.set_location ('BENMGLEINPEFPGM: '||l_pgm_id,20);
754: --
755: -- Set parent eligibility flag info
756: --
757: l_par_elig_state.elig_for_pgm_flag := 'Y';

Line 766: -- hr_utility.set_location ('PTIP Chk '||l_package,10);

762: l_boundary := FALSE;
763: end if;
764: --
765: elsif l_ptip_id is not null then
766: -- hr_utility.set_location ('PTIP Chk '||l_package,10);
767: --
768: l_boundary := FALSE;
769: --
770: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||l_ptip_id,20);

Line 770: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||l_ptip_id,20);

766: -- hr_utility.set_location ('PTIP Chk '||l_package,10);
767: --
768: l_boundary := FALSE;
769: --
770: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||l_ptip_id,20);
771: --
772: -- Check that the PTIP has not been processed. When the PTIP
773: -- has already been processed navigate to the next comp object.
774: -- PTIPs can be duplicated in the comp object list when there

Line 918: -- hr_utility.set_location ('PLIP Chk '||l_package,10);

914: --
915: end if;
916: --
917: elsif l_plip_id is not null then
918: -- hr_utility.set_location ('PLIP Chk '||l_package,10);
919: --
920: l_boundary := FALSE;
921: --
922: -- Check parent comp object eligibility

Line 998: -- hr_utility.set_location ('PLN Chk '||l_package,10);

994: --
995: end if;
996: --
997: elsif l_pl_id is not null then
998: -- hr_utility.set_location ('PLN Chk '||l_package,10);
999: --
1000: l_boundary := FALSE;
1001: --
1002: if l_pl_nip = 'Y' then

Line 1014: hr_utility.set_location('Rule passed for pgm',15);

1010: (p_person_selection_rule_id =>l_person_selection.formula_id,
1011: p_person_id =>p_person_id,
1012: p_business_group_id =>p_business_group_id,
1013: p_effective_date =>p_effective_date) then
1014: hr_utility.set_location('Rule passed for pgm',15);
1015: else
1016: l_failed_rule:=true;
1017: exit;
1018: end if;

Line 1029: hr_utility.set_location('Rule passed for pgm',15);

1025: (p_person_selection_rule_id =>l_person_selection.formula_id,
1026: p_person_id =>p_person_id,
1027: p_business_group_id =>p_business_group_id,
1028: p_effective_date =>p_effective_date) then
1029: hr_utility.set_location('Rule passed for pgm',15);
1030: else
1031: hr_utility.set_location('Rule failed for pgm',15);
1032: l_failed_rule:=true;
1033: exit;

Line 1031: hr_utility.set_location('Rule failed for pgm',15);

1027: p_business_group_id =>p_business_group_id,
1028: p_effective_date =>p_effective_date) then
1029: hr_utility.set_location('Rule passed for pgm',15);
1030: else
1031: hr_utility.set_location('Rule failed for pgm',15);
1032: l_failed_rule:=true;
1033: exit;
1034: end if;
1035: end if;

Line 1147: -- hr_utility.set_location ('OIPL Chk '||l_package,10);

1143: --
1144: end if;
1145: --
1146: elsif l_oipl_id is not null then
1147: -- hr_utility.set_location ('OIPL Chk '||l_package,10);
1148: --
1149: l_boundary := FALSE;
1150: --
1151: -- Check parent comp object eligibility

Line 1235: hr_utility.set_location ('Leaving '||l_package,10);

1231: end if;
1232: --
1233: end loop; -- boundary loop
1234: --
1235: hr_utility.set_location ('Leaving '||l_package,10);
1236: --
1237: p_par_elig_state := l_par_elig_state;
1238: p_treeele_num := l_treeele_num;
1239: p_treeloop := l_treeloop;