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.HR_NL_ORG_INFO dependencies on HR_UTILITY

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

49: --
50: --
51: -- Find the current named organization hierarchy.
52: --
53: hr_utility.set_location('Entering ' || l_proc, 100);
54: OPEN c_hierarchy(vp_organization_id => p_organization_id);
55: FETCH c_hierarchy INTO l_rec;
56: CLOSE c_hierarchy;
57: hr_utility.set_location('Leaving ' || l_proc, 900);

Line 57: hr_utility.set_location('Leaving ' || l_proc, 900);

53: hr_utility.set_location('Entering ' || l_proc, 100);
54: OPEN c_hierarchy(vp_organization_id => p_organization_id);
55: FETCH c_hierarchy INTO l_rec;
56: CLOSE c_hierarchy;
57: hr_utility.set_location('Leaving ' || l_proc, 900);
58: --
59: --
60: -- Return ID.
61: --

Line 65: hr_utility.set_location('Exception :' ||l_proc||SQLERRM(SQLCODE),999);

61: --
62: RETURN l_rec.organization_structure_id;
63: EXCEPTION
64: when others then
65: hr_utility.set_location('Exception :' ||l_proc||SQLERRM(SQLCODE),999);
66: END named_hierarchy;
67: --
68: --
69: -- Service function to return the current version of the named hierarchy.

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

89: --
90: l_rec c_hierarchy_version%ROWTYPE;
91: l_proc varchar2(72) := g_package || '.latest_named_hierarchy_vers';
92: BEGIN
93: hr_utility.set_location('Entering ' || l_proc, 100);
94: --
95: --
96: -- Find the current primary organization hierarchy.
97: --

Line 101: hr_utility.set_location('Leaving ' || l_proc, 900);

97: --
98: OPEN c_hierarchy_version(vp_organization_id => p_organization_id);
99: FETCH c_hierarchy_version INTO l_rec;
100: CLOSE c_hierarchy_version;
101: hr_utility.set_location('Leaving ' || l_proc, 900);
102: --
103: --
104: -- Return ID.
105: --

Line 109: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

105: --
106: RETURN l_rec.org_structure_version_id;
107: EXCEPTION
108: when others then
109: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
110:
111: END latest_named_hierarchy_vers;
112: --
113: --

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

134: --
135: l_rec c_org_exists%ROWTYPE;
136: l_proc varchar2(72) := g_package || '.org_exists_in_hierarchy';
137: BEGIN
138: hr_utility.set_location('Entering ' || l_proc, 100);
139: OPEN c_org_exists(vp_organization_id => p_organization_id);
140: FETCH c_org_exists INTO l_rec;
141: IF c_org_exists%FOUND THEN
142: CLOSE c_org_exists;

Line 143: hr_utility.set_location('Leaving ' || l_proc, 900);

139: OPEN c_org_exists(vp_organization_id => p_organization_id);
140: FETCH c_org_exists INTO l_rec;
141: IF c_org_exists%FOUND THEN
142: CLOSE c_org_exists;
143: hr_utility.set_location('Leaving ' || l_proc, 900);
144: RETURN 'Y';
145: ELSE
146: CLOSE c_org_exists;
147: hr_utility.set_location('Leaving ' || l_proc, 910);

Line 147: hr_utility.set_location('Leaving ' || l_proc, 910);

143: hr_utility.set_location('Leaving ' || l_proc, 900);
144: RETURN 'Y';
145: ELSE
146: CLOSE c_org_exists;
147: hr_utility.set_location('Leaving ' || l_proc, 910);
148: RETURN 'N';
149: END IF;
150: EXCEPTION
151: when others then

Line 152: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

148: RETURN 'N';
149: END IF;
150: EXCEPTION
151: when others then
152: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
153: END org_exists_in_hierarchy;
154:
155: /* -----------------------------------------------------------------------
156: The procedure will return the value of the data item (Region and

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

192: d.organization_id = e.organization_id and
193: d.organization_id = l_org_id and
194: e.org_information_context in ('NL_ORG_INFORMATION');
195: BEGIN
196: hr_utility.set_location('Entering ' || l_proc, 100);
197: temp_region := null;
198: temp_organization_number := null;
199: open org_hierarchy(p_org_id);
200: LOOP

Line 228: hr_utility.set_location('Leaving ' || l_proc, 900);

224: END LOOP;
225: close org_hierarchy;
226: p_region := temp_region;
227: p_organization_number := temp_organization_number;
228: hr_utility.set_location('Leaving ' || l_proc, 900);
229:
230:
231: EXCEPTION
232: when others then

Line 233: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

229:
230:
231: EXCEPTION
232: when others then
233: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
234: p_region := null;
235: p_organization_number := null;
236: END get_org_data_items;
237: /*------------------------------------------------------------------------

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

244: l_organization_id hr_organization_units.organization_id%TYPE;
245: l_level number;
246: l_proc varchar2(72) := g_package || '.chk_for_org_in_hierarchy';
247: BEGIN
248: hr_utility.set_location('Entering ' || l_proc, 100);
249: p_exists := org_exists_in_hierarchy(p_org_id);
250: hr_utility.set_location('Leaving ' || l_proc, 100);
251: END chk_for_org_in_hierarchy;
252: --

Line 250: hr_utility.set_location('Leaving ' || l_proc, 100);

246: l_proc varchar2(72) := g_package || '.chk_for_org_in_hierarchy';
247: BEGIN
248: hr_utility.set_location('Entering ' || l_proc, 100);
249: p_exists := org_exists_in_hierarchy(p_org_id);
250: hr_utility.set_location('Leaving ' || l_proc, 100);
251: END chk_for_org_in_hierarchy;
252: --
253: --
254: -- Function checks to see if organization belongs to the same region from

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

295: v_org_hierarchy org_named_hierarchy%ROWTYPE;
296: b_RegionInfoFound boolean := FALSE;
297: l_proc varchar2(72) := g_package || '.Check_Org_In_Region';
298: BEGIN
299: hr_utility.set_location('Entering ' || l_proc, 100);
300: IF p_region is NOT NULL THEN
301: OPEN org_named_hierarchy(p_org_id);
302: LOOP
303: hr_utility.set_location('Inside ' || l_proc, 105);

Line 303: hr_utility.set_location('Inside ' || l_proc, 105);

299: hr_utility.set_location('Entering ' || l_proc, 100);
300: IF p_region is NOT NULL THEN
301: OPEN org_named_hierarchy(p_org_id);
302: LOOP
303: hr_utility.set_location('Inside ' || l_proc, 105);
304: FETCH org_named_hierarchy INTO v_org_hierarchy;
305: EXIT WHEN org_named_hierarchy%NOTFOUND or b_RegionInfoFound=TRUE;
306: OPEN cur_Region(v_org_hierarchy.organization_id,p_region);
307: FETCH cur_Region INTO v_cur_Region;

Line 308: hr_utility.set_location('Inside ' || l_proc, 110);

304: FETCH org_named_hierarchy INTO v_org_hierarchy;
305: EXIT WHEN org_named_hierarchy%NOTFOUND or b_RegionInfoFound=TRUE;
306: OPEN cur_Region(v_org_hierarchy.organization_id,p_region);
307: FETCH cur_Region INTO v_cur_Region;
308: hr_utility.set_location('Inside ' || l_proc, 110);
309: IF cur_Region%FOUND THEN
310: hr_utility.set_location('Inside ' || l_proc, 115);
311: IF v_cur_Region.Region IS NOT NULL AND
312: v_cur_Region.Region=p_region THEN

Line 310: hr_utility.set_location('Inside ' || l_proc, 115);

306: OPEN cur_Region(v_org_hierarchy.organization_id,p_region);
307: FETCH cur_Region INTO v_cur_Region;
308: hr_utility.set_location('Inside ' || l_proc, 110);
309: IF cur_Region%FOUND THEN
310: hr_utility.set_location('Inside ' || l_proc, 115);
311: IF v_cur_Region.Region IS NOT NULL AND
312: v_cur_Region.Region=p_region THEN
313: hr_utility.set_location('Inside ' || l_proc, 120);
314: l_organization_id := p_org_id;

Line 313: hr_utility.set_location('Inside ' || l_proc, 120);

309: IF cur_Region%FOUND THEN
310: hr_utility.set_location('Inside ' || l_proc, 115);
311: IF v_cur_Region.Region IS NOT NULL AND
312: v_cur_Region.Region=p_region THEN
313: hr_utility.set_location('Inside ' || l_proc, 120);
314: l_organization_id := p_org_id;
315: b_RegionInfoFound := TRUE;
316: ELSIF v_cur_Region.Region IS NOT NULL AND
317: v_cur_Region.Region<>p_region THEN

Line 318: hr_utility.set_location('Inside ' || l_proc, 125);

314: l_organization_id := p_org_id;
315: b_RegionInfoFound := TRUE;
316: ELSIF v_cur_Region.Region IS NOT NULL AND
317: v_cur_Region.Region<>p_region THEN
318: hr_utility.set_location('Inside ' || l_proc, 125);
319: l_organization_id := null;
320: b_RegionInfoFound := TRUE;
321: END IF;
322: END IF;

Line 325: hr_utility.set_location('Inside ' || l_proc, 130);

321: END IF;
322: END IF;
323: CLOSE cur_Region;
324: END LOOP;
325: hr_utility.set_location('Inside ' || l_proc, 130);
326: CLOSE org_named_hierarchy;
327: END IF;
328: hr_utility.set_location('Leaving ' || l_proc, 900);
329: return l_organization_id;

Line 328: hr_utility.set_location('Leaving ' || l_proc, 900);

324: END LOOP;
325: hr_utility.set_location('Inside ' || l_proc, 130);
326: CLOSE org_named_hierarchy;
327: END IF;
328: hr_utility.set_location('Leaving ' || l_proc, 900);
329: return l_organization_id;
330: EXCEPTION
331: when others then
332: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

Line 332: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

328: hr_utility.set_location('Leaving ' || l_proc, 900);
329: return l_organization_id;
330: EXCEPTION
331: when others then
332: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
333: END Check_Org_In_Region;
334: -- Service function which returns the SI Provider information for the given organization.
335: -- It performs tree walk if SI information is not defined for the given organization.
336:

Line 412: hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);

408:
409: /* If Ins Provider at the Asg Level is specified*/
410: IF v_asg_provider.provider IS NOT NULL THEN
411: l_uwv_org_id := v_asg_provider.provider;
412: hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);
413: END IF;
414:
415: /* If Ins Provider at the Asg Level is not specified
416: tree walk to find the Primary Insurance Provider at the level */

Line 417: --hr_utility.set_location('Calling Get_SI_Org_Id',200);

413: END IF;
414:
415: /* If Ins Provider at the Asg Level is not specified
416: tree walk to find the Primary Insurance Provider at the level */
417: --hr_utility.set_location('Calling Get_SI_Org_Id',200);
418:
419: l_org_found := FALSE;
420: l_org_info_id := -1;
421: if org_hierarchy%ISOPEN then

Line 431: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

427: OPEN org_hierarchy(p_organization_id);
428: LOOP
429: FETCH org_hierarchy into l_organization_id,l_level;
430: exit when org_hierarchy%NOTFOUND or l_org_found =TRUE ;
431: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
432: --Fetch UWV Provider assigned to the HR Organization
433: open org_uwv_provider(l_organization_id,l_uwv_org_id,p_si_type);
434: FETCH org_uwv_provider into v_org_uwv_provider;
435: if org_uwv_provider%found then

Line 436: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);

432: --Fetch UWV Provider assigned to the HR Organization
433: open org_uwv_provider(l_organization_id,l_uwv_org_id,p_si_type);
434: FETCH org_uwv_provider into v_org_uwv_provider;
435: if org_uwv_provider%found then
436: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);
437: if l_organization_id =p_organization_id then
438: /*Assign the UWV Provider defined at the HR Org
439: But continue further to see if any Primary
440: UWV exists up in the hierarchy*/

Line 442: --hr_utility.set_location(' Assign -HR Org l_org_info_id'||l_org_info_id,320);

438: /*Assign the UWV Provider defined at the HR Org
439: But continue further to see if any Primary
440: UWV exists up in the hierarchy*/
441: l_org_info_id := v_org_uwv_provider.org_information_id;
442: --hr_utility.set_location(' Assign -HR Org l_org_info_id'||l_org_info_id,320);
443: else
444: /*Assign the UWV Provider defined at the Parent HR Org if
445: not overridden at the HR Org Level*/
446: if l_org_info_id =-1 then

Line 448: --hr_utility.set_location(' Parent HR Org l_org_info_id'||l_org_info_id,330);

444: /*Assign the UWV Provider defined at the Parent HR Org if
445: not overridden at the HR Org Level*/
446: if l_org_info_id =-1 then
447: l_org_info_id := v_org_uwv_provider.org_information_id;
448: --hr_utility.set_location(' Parent HR Org l_org_info_id'||l_org_info_id,330);
449: end if;
450: end if;
451: /*Check If the UWV Provider assigned is also the Primary
452: Quit Searching the hierarchy*/

Line 456: --hr_utility.set_location(' Primary UWV l_org_info_id'||l_org_info_id,340);

452: Quit Searching the hierarchy*/
453: if v_org_uwv_provider.p_flag='Y' then
454: l_org_found:=TRUE;
455: l_org_info_id := v_org_uwv_provider.org_information_id;
456: --hr_utility.set_location(' Primary UWV l_org_info_id'||l_org_info_id,340);
457: end if;
458: end if;
459: close org_uwv_provider;
460: END LOOP;

Line 462: --hr_utility.set_location('Org Info Id :'||l_org_info_id||' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);

458: end if;
459: close org_uwv_provider;
460: END LOOP;
461: close org_hierarchy;
462: --hr_utility.set_location('Org Info Id :'||l_org_info_id||' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
463: RETURN l_org_info_id;
464: EXCEPTION
465: when others then
466: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

Line 466: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

462: --hr_utility.set_location('Org Info Id :'||l_org_info_id||' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
463: RETURN l_org_info_id;
464: EXCEPTION
465: when others then
466: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
467: IF org_hierarchy%ISOPEN THEN
468: CLOSE org_hierarchy;
469: END IF;
470: RETURN -1;

Line 552: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);

548:
549: /* If Ins Provider at the Asg Level is specified*/
550: IF v_asg_provider.provider IS NOT NULL THEN
551: l_uwv_org_id := v_asg_provider.provider;
552: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);
553: ELSE
554: /* If Ins Provider at the Asg Level is not specified
555: tree walk to find the Primary Insurance Provider at the level */
556: --hr_utility.set_location('Calling Get_SI_Org_Id',200);

Line 556: --hr_utility.set_location('Calling Get_SI_Org_Id',200);

552: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);
553: ELSE
554: /* If Ins Provider at the Asg Level is not specified
555: tree walk to find the Primary Insurance Provider at the level */
556: --hr_utility.set_location('Calling Get_SI_Org_Id',200);
557:
558: l_uwv_found := FALSE;
559: l_uwv_org_id := -1;
560: if org_hierarchy%ISOPEN then

Line 570: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

566: OPEN org_hierarchy(p_organization_id);
567: LOOP
568: FETCH org_hierarchy into l_organization_id,l_level;
569: exit when org_hierarchy%NOTFOUND or l_uwv_found =TRUE ;
570: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
571: --Fetch UWV Provider assigned to the HR Organization
572: open org_uwv_provider(l_organization_id,p_si_type);
573: FETCH org_uwv_provider into v_org_uwv_provider;
574: if org_uwv_provider%found then

Line 575: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);

571: --Fetch UWV Provider assigned to the HR Organization
572: open org_uwv_provider(l_organization_id,p_si_type);
573: FETCH org_uwv_provider into v_org_uwv_provider;
574: if org_uwv_provider%found then
575: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);
576: if l_organization_id =p_organization_id then
577: /*Assign the UWV Provider defined at the HR Org
578: But continue further to see if any Primary
579: UWV exists up in the hierarchy*/

Line 581: --hr_utility.set_location(' Assign -HR Org l_uwv_org_id'||l_uwv_org_id,320);

577: /*Assign the UWV Provider defined at the HR Org
578: But continue further to see if any Primary
579: UWV exists up in the hierarchy*/
580: l_uwv_org_id := v_org_uwv_provider.provider;
581: --hr_utility.set_location(' Assign -HR Org l_uwv_org_id'||l_uwv_org_id,320);
582: else
583: /*Assign the UWV Provider defined at the Parent HR Org
584: if not overridden at the HR Org Level*/
585: if l_uwv_org_id =-1 then

Line 587: --hr_utility.set_location(' Parent HR Org l_uwv_org_id'||l_uwv_org_id,330);

583: /*Assign the UWV Provider defined at the Parent HR Org
584: if not overridden at the HR Org Level*/
585: if l_uwv_org_id =-1 then
586: l_uwv_org_id := v_org_uwv_provider.provider;
587: --hr_utility.set_location(' Parent HR Org l_uwv_org_id'||l_uwv_org_id,330);
588: end if;
589: end if;
590: /*Check If the UWV Provider assigned is also the Primary
591: Quit Searching the hierarchy*/

Line 595: --hr_utility.set_location(' Primary UWV l_uwv_org_id'||l_uwv_org_id||' @ '||l_organization_id,340);

591: Quit Searching the hierarchy*/
592: if v_org_uwv_provider.p_flag='Y' then
593: l_uwv_found:=TRUE;
594: l_uwv_org_id := v_org_uwv_provider.provider;
595: --hr_utility.set_location(' Primary UWV l_uwv_org_id'||l_uwv_org_id||' @ '||l_organization_id,340);
596: end if;
597:
598: end if;
599: close org_uwv_provider;

Line 602: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);

598: end if;
599: close org_uwv_provider;
600: END LOOP;
601: close org_hierarchy;
602: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
603:
604: END IF;
605: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
606: RETURN l_uwv_org_id;

Line 605: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);

601: close org_hierarchy;
602: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
603:
604: END IF;
605: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
606: RETURN l_uwv_org_id;
607: EXCEPTION
608: when others then
609: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

Line 609: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

605: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
606: RETURN l_uwv_org_id;
607: EXCEPTION
608: when others then
609: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
610: IF org_hierarchy%ISOPEN THEN
611: CLOSE org_hierarchy;
612: END IF;
613: RETURN -1;

Line 690: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

686: OPEN org_hierarchy(p_organization_id);
687: LOOP
688: FETCH org_hierarchy into l_organization_id,l_level;
689: exit when org_hierarchy%NOTFOUND or l_uwv_found ='Y' ;
690: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
691: --Fetch UWV Provider assigned to the HR Organization
692: open org_uwv_provider(p_uwv_org_id,l_organization_id);
693: FETCH org_uwv_provider into v_org_uwv_provider;
694: IF org_uwv_provider%FOUND THEN

Line 703: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

699: CLOSE org_hierarchy;
700: RETURN l_uwv_found;
701: EXCEPTION
702: when others then
703: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
704: IF org_hierarchy%ISOPEN THEN
705: CLOSE org_hierarchy;
706: END IF;
707: RETURN l_uwv_found;

Line 837: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

833:
834: RETURN l_avg_days;
835: EXCEPTION
836: when others then
837: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
838: IF org_hierarchy%ISOPEN THEN
839: CLOSE org_hierarchy;
840: END IF;
841: RETURN 0;

Line 916: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

912: RETURN l_tax_org_id;
913:
914: EXCEPTION
915: when others then
916: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
917: IF tax_org_hierarchy%ISOPEN THEN
918: CLOSE tax_org_hierarchy;
919: END IF;
920: RETURN null;

Line 974: hr_utility.trace('l_working_hours is : '||l_working_hrs);

970: l_working_hrs:= v_hrs_per_week.working_hours;
971: End if;
972: Close Working_hours_Per_Week;
973:
974: hr_utility.trace('l_working_hours is : '||l_working_hrs);
975:
976: --If the Working_hours_Per_Week is not specified tree walk to find the organization with
977: --the same value defined.
978: --

Line 995: hr_utility.trace('l_working_hours from hierarchy is : '||l_working_hrs);

991: OPEN Working_hours_Per_Week(l_organization_id);
992: Fetch Working_hours_Per_Week into v_hrs_per_week;
993: If Working_hours_Per_Week%FOUND and v_hrs_per_week.working_hours is not null then
994: l_working_hrs:= v_hrs_per_week.working_hours;
995: hr_utility.trace('l_working_hours from hierarchy is : '||l_working_hrs);
996: end if;
997: Close Working_hours_Per_Week;
998: END LOOP;
999: close org_hierarchy;

Line 1007: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1003:
1004: RETURN l_working_hrs;
1005: EXCEPTION
1006: when others then
1007: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1008: IF org_hierarchy%ISOPEN THEN
1009: CLOSE org_hierarchy;
1010: END IF;
1011: RETURN 0;

Line 1104: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1100:
1101: RETURN l_part_time_per;
1102: EXCEPTION
1103: when others then
1104: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1105: IF org_hierarchy%ISOPEN THEN
1106: CLOSE org_hierarchy;
1107: END IF;
1108: RETURN 1;

Line 1200: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1196: END IF;
1197: RETURN l_lunar_method;
1198: EXCEPTION
1199: when others then
1200: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1201: IF org_hierarchy%ISOPEN THEN
1202: CLOSE org_hierarchy;
1203: END IF;
1204: RETURN 0;

Line 1267: hr_utility.trace('l_Pro_Tax_Table is : '||l_Pro_Tax_Table);

1263: l_Pro_Tax_Table:= v_Pro_Tax_Table.Proration_Tax_Table;
1264: End if;
1265: Close cur_Pro_Tax_Table;
1266:
1267: hr_utility.trace('l_Pro_Tax_Table is : '||l_Pro_Tax_Table);
1268:
1269: --If the Working_hours_Per_Week is not specified tree walk
1270: --to find the organization with
1271: --the same value defined.

Line 1305: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1301:
1302: RETURN l_Pro_Tax_Table;
1303: EXCEPTION
1304: when others then
1305: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1306: IF org_hierarchy%ISOPEN THEN
1307: CLOSE org_hierarchy;
1308: END IF;
1309: RETURN '0';

Line 1395: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);

1391: /* If Ins Provider at the Asg Level is specified*/
1392: IF v_asg_provider.provider IS NOT NULL THEN
1393: l_uwv_org_id := v_asg_provider.provider;
1394: l_er_org_id := p_organization_id;
1395: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);
1396: ELSE
1397: /* If Ins Provider at the Asg Level is not specified
1398: tree walk to find the Primary Insurance Provider at the level */
1399: --hr_utility.set_location('Calling Get_SI_Org_Id',200);

Line 1399: --hr_utility.set_location('Calling Get_SI_Org_Id',200);

1395: --hr_utility.set_location('Asg Level UWV Prov l_uwv_org_id'||l_uwv_org_id,100);
1396: ELSE
1397: /* If Ins Provider at the Asg Level is not specified
1398: tree walk to find the Primary Insurance Provider at the level */
1399: --hr_utility.set_location('Calling Get_SI_Org_Id',200);
1400:
1401: l_uwv_found := FALSE;
1402: l_uwv_org_id := -1;
1403: l_er_org_id := -1;

Line 1414: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

1410: OPEN org_hierarchy(p_organization_id);
1411: LOOP
1412: FETCH org_hierarchy into l_organization_id,l_level;
1413: exit when org_hierarchy%NOTFOUND or l_uwv_found =TRUE ;
1414: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
1415: --Fetch UWV Provider assigned to the HR Organization
1416: open org_uwv_provider(l_organization_id,p_si_type);
1417: FETCH org_uwv_provider into v_org_uwv_provider;
1418: if org_uwv_provider%found then

Line 1419: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);

1415: --Fetch UWV Provider assigned to the HR Organization
1416: open org_uwv_provider(l_organization_id,p_si_type);
1417: FETCH org_uwv_provider into v_org_uwv_provider;
1418: if org_uwv_provider%found then
1419: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);
1420: if l_organization_id =p_organization_id then
1421: /*Assign the UWV Provider defined at the HR Org
1422: But continue further to see if any Primary
1423: UWV exists up in the hierarchy*/

Line 1426: --hr_utility.set_location(' Assign -HR Org l_uwv_org_id'||l_uwv_org_id,320);

1422: But continue further to see if any Primary
1423: UWV exists up in the hierarchy*/
1424: l_uwv_org_id := v_org_uwv_provider.provider;
1425: l_er_org_id := l_organization_id;
1426: --hr_utility.set_location(' Assign -HR Org l_uwv_org_id'||l_uwv_org_id,320);
1427: else
1428: /*Assign the UWV Provider defined at the Parent HR Org
1429: if not overridden at the HR Org Level*/
1430: if l_uwv_org_id =-1 then

Line 1433: --hr_utility.set_location(' Parent HR Org l_uwv_org_id'||l_uwv_org_id,330);

1429: if not overridden at the HR Org Level*/
1430: if l_uwv_org_id =-1 then
1431: l_uwv_org_id := v_org_uwv_provider.provider;
1432: l_er_org_id := l_organization_id;
1433: --hr_utility.set_location(' Parent HR Org l_uwv_org_id'||l_uwv_org_id,330);
1434: end if;
1435: end if;
1436: /*Check If the UWV Provider assigned is also the Primary
1437: Quit Searching the hierarchy*/

Line 1442: --hr_utility.set_location(' Primary UWV l_uwv_org_id'||l_uwv_org_id||' @ '||l_organization_id,340);

1438: if v_org_uwv_provider.p_flag='Y' then
1439: l_uwv_found:=TRUE;
1440: l_uwv_org_id := v_org_uwv_provider.provider;
1441: l_er_org_id := l_organization_id;
1442: --hr_utility.set_location(' Primary UWV l_uwv_org_id'||l_uwv_org_id||' @ '||l_organization_id,340);
1443: end if;
1444:
1445: end if;
1446: close org_uwv_provider;

Line 1449: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);

1445: end if;
1446: close org_uwv_provider;
1447: END LOOP;
1448: close org_hierarchy;
1449: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
1450:
1451: END IF;
1452: hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
1453: hr_utility.set_location('ER UWV ID -> l_er_org_id'||l_er_org_id,360);

Line 1452: hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);

1448: close org_hierarchy;
1449: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
1450:
1451: END IF;
1452: hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
1453: hr_utility.set_location('ER UWV ID -> l_er_org_id'||l_er_org_id,360);
1454: RETURN l_er_org_id;
1455: EXCEPTION
1456: when others then

Line 1453: hr_utility.set_location('ER UWV ID -> l_er_org_id'||l_er_org_id,360);

1449: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
1450:
1451: END IF;
1452: hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
1453: hr_utility.set_location('ER UWV ID -> l_er_org_id'||l_er_org_id,360);
1454: RETURN l_er_org_id;
1455: EXCEPTION
1456: when others then
1457: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

Line 1457: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1453: hr_utility.set_location('ER UWV ID -> l_er_org_id'||l_er_org_id,360);
1454: RETURN l_er_org_id;
1455: EXCEPTION
1456: when others then
1457: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1458: IF org_hierarchy%ISOPEN THEN
1459: CLOSE org_hierarchy;
1460: END IF;
1461: RETURN -1;

Line 1596: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1592:
1593: RETURN l_parental_leave_perc;
1594: EXCEPTION
1595: when others then
1596: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1597: IF org_hierarchy%ISOPEN THEN
1598: CLOSE org_hierarchy;
1599: END IF;
1600: RETURN 0;

Line 1640: hr_utility.trace('l_cbs_Rep_Freq is : '||l_cbs_Rep_Freq);

1636: v_Rep_Freq_Table.cbs_reporting_frequency is not null then
1637: l_cbs_Rep_Freq:= v_Rep_Freq_Table.cbs_reporting_frequency;
1638: End if;
1639: Close csr_cbs_rep_freq;
1640: hr_utility.trace('l_cbs_Rep_Freq is : '||l_cbs_Rep_Freq);
1641: --If the Working_hours_Per_Week is not specified tree walk
1642: --to find the organization with
1643: --the same value defined.
1644: --

Line 1673: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1669: END IF;
1670: RETURN l_cbs_Rep_Freq;
1671: EXCEPTION
1672: when others then
1673: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1674: IF org_hierarchy%ISOPEN THEN
1675: CLOSE org_hierarchy;
1676: END IF;
1677: RETURN '0';

Line 1718: hr_utility.trace('l_cbs_cust_num is : '||l_cbs_cust_num);

1714: v_cust_num_table.cbs_cust_number is not null then
1715: l_cbs_cust_num:= v_cust_num_table.cbs_cust_number;
1716: End if;
1717: Close csr_customer_number;
1718: hr_utility.trace('l_cbs_cust_num is : '||l_cbs_cust_num);
1719: --If the Working_hours_Per_Week is not specified tree walk
1720: --to find the organization with
1721: --the same value defined.
1722: --

Line 1746: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1742: END IF;
1743: RETURN l_cbs_cust_num;
1744: EXCEPTION
1745: when others then
1746: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1747: IF org_hierarchy%ISOPEN THEN
1748: CLOSE org_hierarchy;
1749: END IF;
1750: RETURN 'Error';

Line 1790: hr_utility.trace('l_cbs_company_unit is : '||l_cbs_company_unit);

1786: v_company_unit_table.cbs_company_unit is not null then
1787: l_cbs_company_unit:= v_company_unit_table.cbs_company_unit;
1788: End if;
1789: Close csr_company_unit;
1790: hr_utility.trace('l_cbs_company_unit is : '||l_cbs_company_unit);
1791: --If the Working_hours_Per_Week is not specified tree walk
1792: --to find the organization with
1793: --the same value defined.
1794: --

Line 1823: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1819: END IF;
1820: RETURN l_cbs_company_unit;
1821: EXCEPTION
1822: when others then
1823: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1824: IF org_hierarchy%ISOPEN THEN
1825: CLOSE org_hierarchy;
1826: END IF;
1827: RETURN '0';

Line 1866: hr_utility.trace('l_cbs_Rep_Freq is : '||l_cbs_public_sector);

1862: v_public_sector_Table.cbs_public_sector_org is not null then
1863: l_cbs_public_sector:= v_public_sector_Table.cbs_public_sector_org;
1864: End if;
1865: Close csr_public_sector_info;
1866: hr_utility.trace('l_cbs_Rep_Freq is : '||l_cbs_public_sector);
1867:
1868: --
1869: IF l_cbs_public_sector IS NULL THEN
1870: if org_hierarchy%ISOPEN then

Line 1897: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1893: END IF;
1894: RETURN l_cbs_public_sector;
1895: EXCEPTION
1896: when others then
1897: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1898: IF org_hierarchy%ISOPEN THEN
1899: CLOSE org_hierarchy;
1900: END IF;
1901: RETURN '0';

Line 1941: hr_utility.trace('l_cbs_Rep_Freq is : '||l_full_wage_paid);

1937: v_full_sick_wage.full_sick_wage_paid is not null then
1938: l_full_wage_paid:= v_full_sick_wage.full_sick_wage_paid;
1939: End if;
1940: Close csr_full_wage_paid;
1941: hr_utility.trace('l_cbs_Rep_Freq is : '||l_full_wage_paid);
1942:
1943: --
1944: IF l_full_wage_paid IS NULL THEN
1945: if org_hierarchy%ISOPEN then

Line 1968: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

1964:
1965: RETURN l_full_wage_paid;
1966: EXCEPTION
1967: when others then
1968: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
1969: IF org_hierarchy%ISOPEN THEN
1970: CLOSE org_hierarchy;
1971: END IF;
1972: RETURN '0';

Line 2024: hr_utility.trace('l_IZA_Weekly_Hours is : '||l_IZA_Weekly_Hours);

2020: v_IZA_Weekly_Hours_table.IZA_Weekly_Hours is not null then
2021: l_IZA_Weekly_Hours:= v_IZA_Weekly_Hours_table.IZA_Weekly_Hours;
2022: End if;
2023: Close csr_IZA_Weekly_Hours;
2024: hr_utility.trace('l_IZA_Weekly_Hours is : '||l_IZA_Weekly_Hours);
2025: --If the IZA_Weekly_Hours is not specified tree walk
2026: --to find the organization with
2027: --the same value defined.
2028: --

Line 2057: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

2053: END IF;
2054: RETURN l_IZA_Weekly_Hours;
2055: EXCEPTION
2056: when others then
2057: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
2058: IF org_hierarchy%ISOPEN THEN
2059: CLOSE org_hierarchy;
2060: END IF;
2061: RETURN '0';

Line 2114: hr_utility.trace('l_IZA_Monthly_Hours is : '||l_IZA_Monthly_Hours);

2110: v_IZA_Monthly_Hours_table.IZA_Monthly_Hours is not null then
2111: l_IZA_Monthly_Hours:= v_IZA_Monthly_Hours_table.IZA_Monthly_Hours;
2112: End if;
2113: Close csr_IZA_Monthly_Hours;
2114: hr_utility.trace('l_IZA_Monthly_Hours is : '||l_IZA_Monthly_Hours);
2115: --If the IZA_Monthly_Hours is not specified tree walk
2116: --to find the organization with
2117: --the same value defined.
2118: --

Line 2147: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

2143: END IF;
2144: RETURN l_IZA_Monthly_Hours;
2145: EXCEPTION
2146: when others then
2147: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
2148: IF org_hierarchy%ISOPEN THEN
2149: CLOSE org_hierarchy;
2150: END IF;
2151: RETURN '0';

Line 2223: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

2219: RETURN l_iza_org_id;
2220:
2221: EXCEPTION
2222: when others then
2223: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
2224: IF iza_org_hierarchy%ISOPEN THEN
2225: CLOSE iza_org_hierarchy;
2226: END IF;
2227: RETURN null;

Line 2268: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

2264: OPEN org_hierarchy(p_organization_id);
2265: LOOP
2266: FETCH org_hierarchy into l_organization_id,l_level;
2267: exit when org_hierarchy%NOTFOUND or l_uwv_not_found = 0;
2268: --hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
2269: --Fetch UWV Provider assigned to the HR Organization
2270: open org_si_excluded(l_organization_id,p_si_class,p_date_earned);
2271: FETCH org_si_excluded into v_org_si_excluded;
2272: if org_si_excluded%found then

Line 2273: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);

2269: --Fetch UWV Provider assigned to the HR Organization
2270: open org_si_excluded(l_organization_id,p_si_class,p_date_earned);
2271: FETCH org_si_excluded into v_org_si_excluded;
2272: if org_si_excluded%found then
2273: --hr_utility.set_location(' l_organization_id'||l_organization_id||' p_organization_id '||p_organization_id,310);
2274: /*** set the flag which states that this particular SI type is excluded at the HR ORG level ****/
2275: l_uwv_not_found := 0;
2276: end if;
2277: close org_si_excluded;

Line 2280: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);

2276: end if;
2277: close org_si_excluded;
2278: END LOOP;
2279: close org_hierarchy;
2280: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
2281:
2282: --END IF;
2283: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
2284: RETURN l_uwv_not_found;

Line 2283: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);

2279: close org_hierarchy;
2280: --hr_utility.set_location(' UWV From Hierarchy l_uwv_org_id'||l_uwv_org_id,350);
2281:
2282: --END IF;
2283: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
2284: RETURN l_uwv_not_found;
2285: EXCEPTION
2286: when others then
2287: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

Line 2287: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

2283: --hr_utility.set_location(' UWV ID -> l_uwv_org_id'||l_uwv_org_id,360);
2284: RETURN l_uwv_not_found;
2285: EXCEPTION
2286: when others then
2287: hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);
2288: IF org_hierarchy%ISOPEN THEN
2289: CLOSE org_hierarchy;
2290: END IF;
2291: IF org_si_excluded%ISOPEN THEN

Line 2386: hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);

2382: OPEN org_hierarchy(l_org_id);
2383: LOOP
2384: FETCH org_hierarchy into l_organization_id,l_level;
2385: EXIT when org_hierarchy%NOTFOUND or l_lhd_pro_override ='Y' ;
2386: hr_utility.set_location(' l_organization_id'||l_organization_id||' level '||l_level,300);
2387: OPEN csr_get_lhd_override (l_organization_id);
2388: FETCH csr_get_lhd_override INTO v_csr_get_lhd_override;
2389: IF csr_get_lhd_override%FOUND AND v_csr_get_lhd_override.lhd_pro_override IS NOT NULL THEN
2390: l_lhd_pro_override:= v_csr_get_lhd_override.lhd_pro_override;

Line 2401: hr_utility.trace('LHD Proration Override is : '||l_lhd_pro_override);

2397: CLOSE org_hierarchy;
2398: END IF;
2399: END IF;
2400:
2401: hr_utility.trace('LHD Proration Override is : '||l_lhd_pro_override);
2402:
2403: RETURN l_lhd_pro_override;
2404:
2405: EXCEPTION

Line 2407: hr_utility.trace('Exception in get_lhd_proration_override' ||SQLERRM(SQLCODE));

2403: RETURN l_lhd_pro_override;
2404:
2405: EXCEPTION
2406: WHEN OTHERS THEN
2407: hr_utility.trace('Exception in get_lhd_proration_override' ||SQLERRM(SQLCODE));
2408: RETURN 'N';
2409:
2410: END get_lhd_proration_override;
2411: --13959332

Line 2474: hr_utility.set_location (' l_organization_id'|| l_organization_id|| ' level '|| l_level, 300);

2470: , l_level;
2471: EXIT WHEN org_hierarchy%NOTFOUND
2472: OR l_benefi_rule = 'Y';
2473:
2474: hr_utility.set_location (' l_organization_id'|| l_organization_id|| ' level '|| l_level, 300);
2475:
2476: OPEN csr_get_bene_rul_sepa (l_organization_id);
2477: FETCH csr_get_bene_rul_sepa INTO rec_get_bene_rul_sepa;
2478: IF csr_get_bene_rul_sepa%FOUND AND rec_get_bene_rul_sepa.benefi_rule IS NOT NULL THEN

Line 2491: hr_utility.trace ('Beneficial Rule in Separate Run is : '|| l_benefi_rule);

2487: END IF;
2488: END IF;
2489:
2490:
2491: hr_utility.trace ('Beneficial Rule in Separate Run is : '|| l_benefi_rule);
2492:
2493: RETURN l_benefi_rule;
2494:
2495: EXCEPTION

Line 2497: hr_utility.trace ('Exception in get_bene_rul_separate'|| sqlerrm (sqlcode));

2493: RETURN l_benefi_rule;
2494:
2495: EXCEPTION
2496: WHEN others THEN
2497: hr_utility.trace ('Exception in get_bene_rul_separate'|| sqlerrm (sqlcode));
2498: RETURN 'Y';
2499:
2500: END get_b_rule_separate_run;
2501: