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

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

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

Line 113: hr_utility.set_location(' Leaving: '||l_proc, 20);

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

Line 121: hr_utility.set_location('Entering excep:'||l_proc, 35);

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;

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

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

Line 212: hr_utility.set_location('Leaving: '||l_proc, 20);

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

Line 220: hr_utility.set_location('Entering excep:'||l_proc, 35);

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;

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

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

Line 315: hr_utility.set_location('Leaving: '||l_proc, 20);

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:

Line 324: hr_utility.set_location('Entering excep:'||l_proc, 35);

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;

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

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;

Line 383: hr_utility.set_location('Leaving: '||l_proc, 20);

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

Line 391: hr_utility.set_location('Entering excep:'||l_proc, 35);

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;

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

421:
422:
423: BEGIN
424:
425: hr_utility.set_location(' Entering: '||l_proc, 10);
426:
427: OPEN csr_uk_union_rates_table_row;
428:
429: FETCH csr_uk_union_rates_table_row

Line 460: hr_utility.set_location(' Leaving: '||l_proc, 20);

456:
457: END IF;
458:
459: CLOSE csr_uk_union_rates_table_row;
460: hr_utility.set_location(' Leaving: '||l_proc, 20);
461:
462: RETURN l_ret_vlu;
463:
464: -- Added by tmehra for nocopy changes Feb'03

Line 468: hr_utility.set_location('Entering excep:'||l_proc, 35);

464: -- Added by tmehra for nocopy changes Feb'03
465:
466: EXCEPTION
467: WHEN OTHERS THEN
468: hr_utility.set_location('Entering excep:'||l_proc, 35);
469: p_union_rates_row_value := NULL;
470: p_ERROR_MESSAGE := SQLERRM;
471: raise;
472:

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

490: l_proc VARCHAR2(61):= g_proc||'get_uk_union_rates';
491:
492: BEGIN
493:
494: hr_utility.set_location(' Entering: '||l_proc, 10);
495:
496: p_Union_Deduction_Value := hruserdt.get_table_value
497: (p_bus_group_id
498: ,p_union_rates_table_name

Line 504: hr_utility.set_location(' Leaving: '||l_proc, 20);

500: ,p_union_rates_row_value
501: ,p_effective_date -- Default Sesn Date
502: );
503:
504: hr_utility.set_location(' Leaving: '||l_proc, 20);
505:
506: RETURN 0;
507: EXCEPTION
508:

Line 529: -- hr_utility.set_message('8303','PQP_UNDTEST_RATESFUN_OTHERS');

525:
526:
527: --WHEN OTHERS THEN
528: -- p_Union_Deduction_Value := 0;
529: -- hr_utility.set_message('8303','PQP_UNDTEST_RATESFUN_OTHERS');
530: -- hr_utility.raise_error;
531:
532: -- Added by tmehra for nocopy changes Feb'03
533:

Line 530: -- hr_utility.raise_error;

526:
527: --WHEN OTHERS THEN
528: -- p_Union_Deduction_Value := 0;
529: -- hr_utility.set_message('8303','PQP_UNDTEST_RATESFUN_OTHERS');
530: -- hr_utility.raise_error;
531:
532: -- Added by tmehra for nocopy changes Feb'03
533:
534: WHEN OTHERS THEN

Line 539: hr_utility.set_location('Entering excep:'||l_proc, 35);

535:
536: p_Union_Deduction_Value := NULL;
537: p_ERROR_MESSAGE := SQLERRM;
538:
539: hr_utility.set_location('Entering excep:'||l_proc, 35);
540: raise;
541:
542: END get_uk_union_rates;
543: