[Home] [Help]
81:
82:
83: BEGIN
84:
85: hr_utility.set_location(' Entering: '||l_proc, 10);
86:
87: OPEN csr_get_union_ele_extra_info;
88:
89: FETCH csr_get_union_ele_extra_info
109: END IF;
110:
111: CLOSE csr_get_union_ele_extra_info;
112:
113: hr_utility.set_location(' Leaving: '||l_proc, 20);
114:
115: RETURN l_ret_vlu;
116:
117: -- Added by tmehra for nocopy changes Feb'03
117: -- Added by tmehra for nocopy changes Feb'03
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: hr_utility.set_location('Entering excep:'||l_proc, 35);
122:
123: p_union_organization_id := NULL;
124: p_union_level_balance_name := NULL;
125: p_pension_rate_type_name := NULL;
188:
189: BEGIN
190:
191:
192: hr_utility.set_location(' Entering: '||l_proc, 10);
193:
194: OPEN csr_get_union_org_info;
195:
196: FETCH csr_get_union_org_info
208:
209: END IF;
210:
211: CLOSE csr_get_union_org_info;
212: hr_utility.set_location('Leaving: '||l_proc, 20);
213:
214: RETURN l_ret_vlu;
215:
216: -- Added by tmehra for nocopy changes Feb'03
216: -- Added by tmehra for nocopy changes Feb'03
217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: hr_utility.set_location('Entering excep:'||l_proc, 35);
221:
222: p_union_rates_table_id := NULL;
223: p_union_rates_table_name := NULL;
224: p_union_rates_table_type := NULL;
289:
290: BEGIN
291:
292:
293: hr_utility.set_location(' Entering: '||l_proc, 10);
294:
295: OPEN csr_get_union_org_info;
296:
297: FETCH csr_get_union_org_info
311:
312: END IF;
313:
314: CLOSE csr_get_union_org_info;
315: hr_utility.set_location('Leaving: '||l_proc, 20);
316:
317: RETURN l_ret_vlu;
318:
319:
320: -- Added by tmehra for nocopy changes Feb'03
321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: hr_utility.set_location('Entering excep:'||l_proc, 35);
325:
326: p_union_rates_table_id := NULL;
327: p_union_rates_table_name := NULL;
328: p_union_rates_table_type := NULL;
358: AND cols.user_column_name = p_union_rates_column_name;
359:
360: BEGIN
361:
362: hr_utility.set_location(' Entering: '||l_proc, 10);
363:
364: l_error_message_nc := p_error_message;
365:
366: OPEN csr_uk_union_fund_selected;
379:
380: END IF;
381:
382: CLOSE csr_uk_union_fund_selected;
383: hr_utility.set_location('Leaving: '||l_proc, 20);
384:
385: RETURN l_ret_vlu;
386:
387: -- Added by tmehra for nocopy changes Feb'03
387: -- Added by tmehra for nocopy changes Feb'03
388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: hr_utility.set_location('Entering excep:'||l_proc, 35);
392: p_error_message := l_error_message_nc;
393: raise;
394:
395: END chk_uk_union_fund_selected;
424:
425:
426: BEGIN
427:
428: hr_utility.set_location(' Entering: '||l_proc, 10);
429: l_business_group_id := FND_GLOBAL.per_business_group_id;
430: hr_utility.set_location('Business_group_id in get_uk_union_rates_table_row is: '||l_business_group_id, 15);
431:
432: OPEN csr_uk_union_rates_table_row(l_business_group_id);
426: BEGIN
427:
428: hr_utility.set_location(' Entering: '||l_proc, 10);
429: l_business_group_id := FND_GLOBAL.per_business_group_id;
430: hr_utility.set_location('Business_group_id in get_uk_union_rates_table_row is: '||l_business_group_id, 15);
431:
432: OPEN csr_uk_union_rates_table_row(l_business_group_id);
433: loop
434: FETCH csr_uk_union_rates_table_row
433: loop
434: FETCH csr_uk_union_rates_table_row
435: INTO p_union_rates_row_value;
436: exit when csr_uk_union_rates_table_row%notfound;
437: hr_utility.trace('value fetched :' ||p_union_rates_row_value);
438: end loop;
439:
440: if csr_uk_union_rates_table_row%rowcount = 0 then
441: l_ret_vlu := -1;
442: p_ERROR_MESSAGE :=
443: -- 'No rows were found for a given exact match union rates table.';
444: 'Add the values for the flat rate union deductions to the '||
445: p_union_rates_table_name||' table.';
446: hr_utility.trace('No rows found');
447:
448: elsif csr_uk_union_rates_table_row%rowcount >1 then
449: l_ret_vlu := -1;
450: p_ERROR_MESSAGE :=
454: 'includes a single description of flat rate deductions.';
455: end if;
456: close csr_uk_union_rates_table_row;
457:
458: hr_utility.set_location(' Leaving: '||l_proc, 20);
459:
460: RETURN l_ret_vlu;
461:
462: -- Added by tmehra for nocopy changes Feb'03
462: -- Added by tmehra for nocopy changes Feb'03
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: hr_utility.set_location('Entering excep:'||l_proc, 35);
467: p_union_rates_row_value := NULL;
468: p_ERROR_MESSAGE := SQLERRM;
469: raise;
470:
488: l_proc VARCHAR2(61):= g_proc||'get_uk_union_rates';
489:
490: BEGIN
491:
492: hr_utility.set_location(' Entering: '||l_proc, 10);
493:
494: p_Union_Deduction_Value := hruserdt.get_table_value
495: (p_bus_group_id
496: ,p_union_rates_table_name
498: ,p_union_rates_row_value
499: ,p_effective_date -- Default Sesn Date
500: );
501:
502: hr_utility.set_location(' Leaving: '||l_proc, 20);
503:
504: RETURN 0;
505: EXCEPTION
506:
523:
524:
525: --WHEN OTHERS THEN
526: -- p_Union_Deduction_Value := 0;
527: -- hr_utility.set_message('8303','PQP_UNDTEST_RATESFUN_OTHERS');
528: -- hr_utility.raise_error;
529:
530: -- Added by tmehra for nocopy changes Feb'03
531:
524:
525: --WHEN OTHERS THEN
526: -- p_Union_Deduction_Value := 0;
527: -- hr_utility.set_message('8303','PQP_UNDTEST_RATESFUN_OTHERS');
528: -- hr_utility.raise_error;
529:
530: -- Added by tmehra for nocopy changes Feb'03
531:
532: WHEN OTHERS THEN
533:
534: p_Union_Deduction_Value := NULL;
535: p_ERROR_MESSAGE := SQLERRM;
536:
537: hr_utility.set_location('Entering excep:'||l_proc, 35);
538: raise;
539:
540: END get_uk_union_rates;
541: