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.

[Home] [Help]

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 1595: --hr_utility.set_location('Exception :' || l_proc||SQLERRM(SQLCODE),999);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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