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 412: -- hr_utility.set_location ('Dn PTIP PILPEP ' || l_package,10);

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

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

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

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

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

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

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

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

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

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

459: -- hr_utility.set_location ('Dn PL PILPEP ' || l_package,10);
460: --
461: elsif p_comp_obj_tree_row.oipl_id is not null then
462: --
463: -- hr_utility.set_location ('OIPL PILPEP ' || l_package,10);
464: -- Bug 8351660: passed the fonm date in the call to ben_pep_cache.get_pilepo_dets
465: ben_pep_cache.get_pilepo_dets
466: (p_person_id => p_person_id
467: ,p_business_group_id => p_business_group_id

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

479: l_prevelig := TRUE;
480: --
481: end if;
482: --
483: -- hr_utility.set_location ('Dn OIPL PILPEP ' || l_package,10);
484: --
485: end if;
486: --
487: return l_prevelig;

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

618: order by 1 ;
619: --
620: begin
621: l_proc := g_package||'get_new_date';
622: hr_utility.set_location('Entering '||l_proc,10);
623: l_mode := p_mode;
624: l_treeele_num := p_treeele_num;
625: if l_mode not in ('A','P','S','T') then --a
626: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071

Line 628: hr_utility.set_location('mode'||l_mode,10);

624: l_treeele_num := p_treeele_num;
625: if l_mode not in ('A','P','S','T') then --a
626: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
627:
628: hr_utility.set_location('mode'||l_mode,10);
629: --
630: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
631: if (l_mode = 'U'or l_mode = 'R' or l_mode = 'D') then --b
632:

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

711:
712: l_effective_date :=nvl(l_rec.lf_evt_ocrd_dt,p_effective_date);
713: l_new_effective_date := nvl(l_rec.lf_evt_ocrd_dt,p_effective_date);
714:
715: hr_utility.set_location('l_effective_date '||l_effective_date,10);
716: hr_utility.set_location('l_new_effective_date '||l_new_effective_date,10);
717:
718: if l_mode in ('L') then
719:

Line 716: hr_utility.set_location('l_new_effective_date '||l_new_effective_date,10);

712: l_effective_date :=nvl(l_rec.lf_evt_ocrd_dt,p_effective_date);
713: l_new_effective_date := nvl(l_rec.lf_evt_ocrd_dt,p_effective_date);
714:
715: hr_utility.set_location('l_effective_date '||l_effective_date,10);
716: hr_utility.set_location('l_new_effective_date '||l_new_effective_date,10);
717:
718: if l_mode in ('L') then
719:
720: open c_lee_rsn(c_pl_id => p_comp_obj_tree(l_treeele_num).par_pl_id,

Line 729: hr_utility.set_location('l_effective_date '||l_effective_date,20);

725: close c_lee_rsn ;
726:
727: end if;
728:
729: hr_utility.set_location('l_effective_date '||l_effective_date,20);
730:
731: ben_use_cvg_rt_date.get_csd_rsd_Status
732: (p_pgm_id => p_comp_obj_tree(l_treeele_num).par_pgm_id
733: ,p_ptip_id => p_comp_obj_tree(l_treeele_num).par_ptip_id

Line 740: hr_utility.set_location('l_fonm_cd '||l_fonm_cd,10);

736: ,p_effective_date => p_effective_date
737: ,p_status => l_fonm_cd
738: ) ;
739:
740: hr_utility.set_location('l_fonm_cd '||l_fonm_cd,10);
741:
742: if l_fonm_cd = 'Y' then
743: ben_determine_date.rate_and_coverage_dates
744: (p_cache_mode => TRUE

Line 781: hr_utility.set_location('p_new_effective_date '||p_new_effective_date,10);

777:
778: p_new_effective_date := l_new_effective_date;
779: p_effective_date_1 := l_effective_date;
780:
781: hr_utility.set_location('p_new_effective_date '||p_new_effective_date,10);
782: hr_utility.set_location('p_effective_date_1 '||p_effective_date_1,10);
783: hr_utility.set_location('Leaving '||l_proc,10);
784:
785: /*exception

Line 782: hr_utility.set_location('p_effective_date_1 '||p_effective_date_1,10);

778: p_new_effective_date := l_new_effective_date;
779: p_effective_date_1 := l_effective_date;
780:
781: hr_utility.set_location('p_new_effective_date '||p_new_effective_date,10);
782: hr_utility.set_location('p_effective_date_1 '||p_effective_date_1,10);
783: hr_utility.set_location('Leaving '||l_proc,10);
784:
785: /*exception
786: when others then

Line 783: hr_utility.set_location('Leaving '||l_proc,10);

779: p_effective_date_1 := l_effective_date;
780:
781: hr_utility.set_location('p_new_effective_date '||p_new_effective_date,10);
782: hr_utility.set_location('p_effective_date_1 '||p_effective_date_1,10);
783: hr_utility.set_location('Leaving '||l_proc,10);
784:
785: /*exception
786: when others then
787: hr_utility.set_location('SQLERRM '||sqlerrm,10);*/

Line 787: hr_utility.set_location('SQLERRM '||sqlerrm,10);*/

783: hr_utility.set_location('Leaving '||l_proc,10);
784:
785: /*exception
786: when others then
787: hr_utility.set_location('SQLERRM '||sqlerrm,10);*/
788:
789: end get_new_date;
790:
791: --Bug 13257261 changes end

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

932: order by ordr_to_aply_num;
933: --
934: begin
935: --
936: hr_utility.set_location ('Entering '||l_package,10);
937: --
938: l_par_elig_state := p_par_elig_state;
939: l_treeele_num := p_treeele_num;
940: --

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

942: --
943: -- Comp object navigation loop. Only loop if a boundary is hit
944: --
945: loop
946: hr_utility.set_location ('St CO Tree Loop '||l_package,10);
947: --
948: --Bug 13257261 changes Start
949: get_new_date
950: (p_comp_obj_tree => p_comp_obj_tree

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

973: --
974: -- Initialise parent eligibility flags
975: --
976: if l_pgm_id is not null then
977: hr_utility.set_location ('PGM Chk '||l_package,10);
978: --
979: l_failed_rule:=false;
980: -- PB : 5422 : if p_popl_enrt_typ_cycl_id is not null then
981: if p_lf_evt_ocrd_dt is not null then

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

985: (p_person_selection_rule_id =>l_person_selection.formula_id,
986: p_person_id =>p_person_id,
987: p_business_group_id =>p_business_group_id,
988: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
989: hr_utility.set_location('Rule passed for pgm',15);
990: else
991: l_failed_rule:=true;
992: exit;
993: end if;

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

1000: (p_person_selection_rule_id =>l_person_selection.formula_id,
1001: p_person_id =>p_person_id,
1002: p_business_group_id =>p_business_group_id,
1003: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
1004: hr_utility.set_location('Rule passed for pgm',15);
1005: else
1006: hr_utility.set_location('Rule failed for pgm',15);
1007: l_failed_rule:=true;
1008: exit;

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

1002: p_business_group_id =>p_business_group_id,
1003: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
1004: hr_utility.set_location('Rule passed for pgm',15);
1005: else
1006: hr_utility.set_location('Rule failed for pgm',15);
1007: l_failed_rule:=true;
1008: exit;
1009: end if;
1010: end if;

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

1031: --
1032: end if;
1033: end loop;
1034: else
1035: hr_utility.set_location ('BENMGLEINPEFPGM: '||l_pgm_id,20);
1036: --
1037: -- Set parent eligibility flag info
1038: --
1039: l_par_elig_state.elig_for_pgm_flag := 'Y';

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

1044: l_boundary := FALSE;
1045: end if;
1046: --
1047: elsif l_ptip_id is not null then
1048: -- hr_utility.set_location ('PTIP Chk '||l_package,10);
1049: --
1050: l_boundary := FALSE;
1051: --
1052: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||l_ptip_id,20);

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

1048: -- hr_utility.set_location ('PTIP Chk '||l_package,10);
1049: --
1050: l_boundary := FALSE;
1051: --
1052: -- hr_utility.set_location ('BENMGLEINPEFPTIP: '||l_ptip_id,20);
1053: --
1054: -- Check that the PTIP has not been processed. When the PTIP
1055: -- has already been processed navigate to the next comp object.
1056: -- PTIPs can be duplicated in the comp object list when there

Line 1186: -- hr_utility.set_location ('Setting elig_for_ptip_flag to N before exiting ',70);

1182: if p_comp_obj_tree(l_treeele_num).plip_id is not null or
1183: p_comp_obj_tree(l_treeele_num).pl_id is not null or
1184: p_comp_obj_tree(l_treeele_num).oipl_id is not null then
1185:
1186: -- hr_utility.set_location ('Setting elig_for_ptip_flag to N before exiting ',70);
1187: -- l_par_elig_state.elig_for_ptip_flag := 'N';
1188:
1189: --Bug 13257261 setting parent compensation object's elig flags to 'N'
1190: if p_comp_obj_tree(l_treeele_num).plip_id is not null

Line 1192: hr_utility.set_location ('Setting elig_for_ptip_flag to N before exiting ',70);

1188:
1189: --Bug 13257261 setting parent compensation object's elig flags to 'N'
1190: if p_comp_obj_tree(l_treeele_num).plip_id is not null
1191: then
1192: hr_utility.set_location ('Setting elig_for_ptip_flag to N before exiting ',70);
1193: l_par_elig_state.elig_for_ptip_flag := 'N';
1194: end if;
1195:
1196: if p_comp_obj_tree(l_treeele_num).pl_id is not null then

Line 1197: hr_utility.set_location ('Setting ptip and plip to N before exiting ',70);

1193: l_par_elig_state.elig_for_ptip_flag := 'N';
1194: end if;
1195:
1196: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1197: hr_utility.set_location ('Setting ptip and plip to N before exiting ',70);
1198: l_par_elig_state.elig_for_ptip_flag := 'N';
1199: l_par_elig_state.elig_for_plip_flag := 'N';
1200: end if;
1201:

Line 1203: hr_utility.set_location ('Setting ptip and plip and pl to N before exiting ',70);

1199: l_par_elig_state.elig_for_plip_flag := 'N';
1200: end if;
1201:
1202: if p_comp_obj_tree(l_treeele_num).oipl_id is not null then
1203: hr_utility.set_location ('Setting ptip and plip and pl to N before exiting ',70);
1204: l_par_elig_state.elig_for_ptip_flag := 'N';
1205: l_par_elig_state.elig_for_plip_flag := 'N';
1206: l_par_elig_state.elig_for_pl_flag := 'N';
1207: end if;

Line 1223: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).ptip_id'||p_comp_obj_tree(l_treeele_num).ptip_id,10);

1219: --If the Compensation object is first ineligible or still ineligible then inserting the
1220: --comp object into globle variables to check whether any future records are there in
1221: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1222: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1223: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).ptip_id'||p_comp_obj_tree(l_treeele_num).ptip_id,10);
1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:

Line 1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);

1220: --comp object into globle variables to check whether any future records are there in
1221: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1222: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1223: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).ptip_id'||p_comp_obj_tree(l_treeele_num).ptip_id,10);
1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;

Line 1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);

1221: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1222: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1223: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).ptip_id'||p_comp_obj_tree(l_treeele_num).ptip_id,10);
1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object

Line 1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);

1222: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1223: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).ptip_id'||p_comp_obj_tree(l_treeele_num).ptip_id,10);
1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=

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

1291: --
1292: end if;
1293: --
1294: elsif l_plip_id is not null then
1295: -- hr_utility.set_location ('PLIP Chk '||l_package,10);
1296: --
1297: l_boundary := FALSE;
1298: --
1299: -- Check parent comp object eligibility

Line 1362: -- hr_utility.set_location ('Setting elig_for_plip_flag to N before exiting ',70);

1358: -- if at point of exit, the comp object is a child of plip
1359: if p_comp_obj_tree(l_treeele_num).pl_id is not null or
1360: p_comp_obj_tree(l_treeele_num).oipl_id is not null then
1361:
1362: -- hr_utility.set_location ('Setting elig_for_plip_flag to N before exiting ',70);
1363: -- l_par_elig_state.elig_for_plip_flag := 'N';
1364: --
1365:
1366: --Bug 13257261 setting parent compensation object's elig flags to 'N'

Line 1368: hr_utility.set_location ('Setting elig_for_plip_flag to N before exiting ',70);

1364: --
1365:
1366: --Bug 13257261 setting parent compensation object's elig flags to 'N'
1367: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1368: hr_utility.set_location ('Setting elig_for_plip_flag to N before exiting ',70);
1369: l_par_elig_state.elig_for_plip_flag := 'N';
1370: end if;
1371:
1372: if p_comp_obj_tree(l_treeele_num).oipl_id is not null then

Line 1373: hr_utility.set_location ('Setting plip and pl to N before exiting ',70);

1369: l_par_elig_state.elig_for_plip_flag := 'N';
1370: end if;
1371:
1372: if p_comp_obj_tree(l_treeele_num).oipl_id is not null then
1373: hr_utility.set_location ('Setting plip and pl to N before exiting ',70);
1374: l_par_elig_state.elig_for_plip_flag := 'N';
1375: l_par_elig_state.elig_for_pl_flag := 'N';
1376: end if;
1377:

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

1430: --
1431: end if;
1432: --
1433: elsif l_pl_id is not null then
1434: -- hr_utility.set_location ('PLN Chk '||l_package,10);
1435: --
1436: l_boundary := FALSE;
1437: --
1438: if l_pl_nip = 'Y' then

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

1446: (p_person_selection_rule_id =>l_person_selection.formula_id,
1447: p_person_id =>p_person_id,
1448: p_business_group_id =>p_business_group_id,
1449: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
1450: hr_utility.set_location('Rule passed for pgm',15);
1451: else
1452: l_failed_rule:=true;
1453: exit;
1454: end if;

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

1461: (p_person_selection_rule_id =>l_person_selection.formula_id,
1462: p_person_id =>p_person_id,
1463: p_business_group_id =>p_business_group_id,
1464: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
1465: hr_utility.set_location('Rule passed for pgm',15);
1466: else
1467: hr_utility.set_location('Rule failed for pgm',15);
1468: l_failed_rule:=true;
1469: exit;

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

1463: p_business_group_id =>p_business_group_id,
1464: p_effective_date =>l_effective_date) then -- 12715758 changed p_effective_date to l_effective_date
1465: hr_utility.set_location('Rule passed for pgm',15);
1466: else
1467: hr_utility.set_location('Rule failed for pgm',15);
1468: l_failed_rule:=true;
1469: exit;
1470: end if;
1471: end if;

Line 1568: hr_utility.set_location ('Setting elig_for_pl_flag to N before exiting ',70);

1564: -- At this point, the parent pl is not eligible. So, the elig_for_pl_flag should be set to N,
1565: -- if at point of exit, the comp object is a child of pl
1566:
1567: if p_comp_obj_tree(l_treeele_num).oipl_id is not null then
1568: hr_utility.set_location ('Setting elig_for_pl_flag to N before exiting ',70);
1569: l_par_elig_state.elig_for_pl_flag := 'N';
1570: end if;
1571: -- bug # 5929587
1572:

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

1613: --
1614: end if;
1615: --
1616: elsif l_oipl_id is not null then
1617: -- hr_utility.set_location ('OIPL Chk '||l_package,10);
1618: --
1619: l_boundary := FALSE;
1620: --
1621: -- Check parent comp object eligibility

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

1701: end if;
1702: --
1703: end loop; -- boundary loop
1704: --
1705: hr_utility.set_location ('Leaving '||l_package,10);
1706: --
1707: p_par_elig_state := l_par_elig_state;
1708: p_treeele_num := l_treeele_num;
1709: p_treeloop := l_treeloop;