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

Line 68: hr_utility.set_location('Entering '||l_procedure,10);

64: BEGIN
65: --
66: --
67: l_procedure := g_package_name || '.current_and_ytd_balances';
68: hr_utility.set_location('Entering '||l_procedure,10);
69: --
70: hr_utility.set_location('Fetching value of ' ||p_balance_name|| '_ASG_PTD',20);
71:
72: OPEN c_balance_value('_ASG_PTD');

Line 70: hr_utility.set_location('Fetching value of ' ||p_balance_name|| '_ASG_PTD',20);

66: --
67: l_procedure := g_package_name || '.current_and_ytd_balances';
68: hr_utility.set_location('Entering '||l_procedure,10);
69: --
70: hr_utility.set_location('Fetching value of ' ||p_balance_name|| '_ASG_PTD',20);
71:
72: OPEN c_balance_value('_ASG_PTD');
73: FETCH c_balance_value INTO l_curr_balance;
74: CLOSE c_balance_value;

Line 76: hr_utility.set_location('Fetching value of '||p_balance_name||'_ASG_PTD',30);

72: OPEN c_balance_value('_ASG_PTD');
73: FETCH c_balance_value INTO l_curr_balance;
74: CLOSE c_balance_value;
75:
76: hr_utility.set_location('Fetching value of '||p_balance_name||'_ASG_PTD',30);
77:
78: OPEN c_balance_value('_ASG_YTD');
79: FETCH c_balance_value INTO l_ytd_balance;
80: CLOSE c_balance_value;

Line 86: hr_utility.set_location('Leaving '||l_procedure,40);

82: p_current_balance := l_curr_balance;
83: p_ytd_balance := l_ytd_balance;
84:
85: --
86: hr_utility.set_location('Leaving '||l_procedure,40);
87: --
88: EXCEPTION
89: --
90: WHEN others THEN

Line 91: hr_utility.set_location('Error in '||l_procedure,50);

87: --
88: EXCEPTION
89: --
90: WHEN others THEN
91: hr_utility.set_location('Error in '||l_procedure,50);
92: IF c_balance_value%ISOPEN THEN
93: CLOSE c_balance_value;
94: END IF;
95: RAISE;

Line 225: hr_utility.set_location('Entering '||l_procedure,10);

221: --
222: BEGIN
223: --
224: l_procedure := g_package_name || '.balance_totals';
225: hr_utility.set_location('Entering '||l_procedure,10);
226:
227: -- Call procedure to get Current and YTD balances for Payment Summary Totals
228:
229: hr_utility.set_location('Fetching value of Taxable Earnings balance',20);

Line 229: hr_utility.set_location('Fetching value of Taxable Earnings balance',20);

225: hr_utility.set_location('Entering '||l_procedure,10);
226:
227: -- Call procedure to get Current and YTD balances for Payment Summary Totals
228:
229: hr_utility.set_location('Fetching value of Taxable Earnings balance',20);
230:
231: current_and_ytd_balances (
232: p_prepaid_tag => p_prepaid_tag
233: ,p_assignment_action_id => p_assignment_action_id

Line 243: hr_utility.set_location('Fetching value of Severance Earnings balance',22);

239:
240: -- Bug 3116630 starts
241: -- The following balances should be added up to 'Taxable Earnings' Balance
242: --
243: hr_utility.set_location('Fetching value of Severance Earnings balance',22);
244:
245: current_and_ytd_balances (
246: p_prepaid_tag => p_prepaid_tag
247: ,p_assignment_action_id => p_assignment_action_id

Line 256: hr_utility.set_location('Fetching value of Annual Bonus balance',24);

252:
253: -- Bug 4303538 starts
254: -- The following balance should be added up to 'Taxable Earnings' Balance
255: --
256: hr_utility.set_location('Fetching value of Annual Bonus balance',24);
257:
258: current_and_ytd_balances (
259: p_prepaid_tag => p_prepaid_tag
260: ,p_assignment_action_id => p_assignment_action_id

Line 267: hr_utility.set_location('Fetching value of Special Payments Separate balance',25);

263: ,p_ytd_balance => l_annual_bonus_ytd
264: );
265: -- Bug 4303538 ends
266:
267: hr_utility.set_location('Fetching value of Special Payments Separate balance',25);
268:
269: current_and_ytd_balances (
270: p_prepaid_tag => p_prepaid_tag
271: ,p_assignment_action_id => p_assignment_action_id

Line 278: hr_utility.set_location('Fetching value of Special Payments Spread balance',27);

274: ,p_ytd_balance => l_spec_separate_ytd
275: );
276:
277:
278: hr_utility.set_location('Fetching value of Special Payments Spread balance',27);
279:
280: current_and_ytd_balances (
281: p_prepaid_tag => p_prepaid_tag
282: ,p_assignment_action_id => p_assignment_action_id

Line 292: hr_utility.set_location('Fetching value of Retro Taxable Earnings balance',28);

288: -- Bug 3290973 Starts
289: -- Fetch 'Retro Taxable Earnings' and 'Retro Special Payments' Balances and them
290: -- to 'Taxable Earnings' Balance
291:
292: hr_utility.set_location('Fetching value of Retro Taxable Earnings balance',28);
293:
294: current_and_ytd_balances (
295: p_prepaid_tag => p_prepaid_tag
296: ,p_assignment_action_id => p_assignment_action_id

Line 302: hr_utility.set_location('Fetching value of Retro Special Payments balance',28);

298: ,p_current_balance => l_retro_tax_earnings_current
299: ,p_ytd_balance => l_retro_tax_earnings_ytd
300: );
301:
302: hr_utility.set_location('Fetching value of Retro Special Payments balance',28);
303:
304: current_and_ytd_balances (
305: p_prepaid_tag => p_prepaid_tag
306: ,p_assignment_action_id => p_assignment_action_id

Line 315: hr_utility.set_location('Fetching value of Retro Annual Bonus balance',28);

311:
312: -- Bug 4303538 starts
313: -- The following balance should be added up to 'Taxable Earnings' Balance
314: --
315: hr_utility.set_location('Fetching value of Retro Annual Bonus balance',28);
316:
317: current_and_ytd_balances (
318: p_prepaid_tag => p_prepaid_tag
319: ,p_assignment_action_id => p_assignment_action_id

Line 326: hr_utility.set_location('Fetching value of Variable Yearly Earnings balance',28);

322: ,p_ytd_balance => l_retro_ann_bonus_ytd
323: );
324: -- Bug 4303538 ends
325:
326: hr_utility.set_location('Fetching value of Variable Yearly Earnings balance',28);
327:
328: --
329: -- Bug 3812288 Changes start
330: --

Line 339: hr_utility.set_location('Fetching value of Retro Variable yearly Earnings balance',28);

335: ,p_current_balance => l_var_yrly_pay_current
336: ,p_ytd_balance => l_var_yrly_pay_ytd
337: );
338:
339: hr_utility.set_location('Fetching value of Retro Variable yearly Earnings balance',28);
340:
341: current_and_ytd_balances (
342: p_prepaid_tag => p_prepaid_tag
343: ,p_assignment_action_id => p_assignment_action_id

Line 372: hr_utility.set_location('Fetching value of Non Taxable Earnings balance',30);

368: -- Bug 3290973 ends
369:
370: -- Bug 3116630 ends
371:
372: hr_utility.set_location('Fetching value of Non Taxable Earnings balance',30);
373:
374: current_and_ytd_balances (
375: p_prepaid_tag => p_prepaid_tag
376: ,p_assignment_action_id => p_assignment_action_id

Line 386: hr_utility.set_location('Fetching Value of Direct payments balance',35);

382: -- Bug 3198882 : Changes Start
383: -- Included the 'Direct Payments' PTD and YTD balance values in 'Non Taxable Earnings'
384: -- PTD and YTD balances for archival
385:
386: hr_utility.set_location('Fetching Value of Direct payments balance',35);
387:
388: current_and_ytd_balances (
389: p_prepaid_tag => p_prepaid_tag
390: ,p_assignment_action_id => p_assignment_action_id

Line 403: hr_utility.set_location('Fetching value of Voluntary Deductions balance',40);

399: l_tot_non_taxable_earnings_ytd := l_non_taxable_earnings_ytd + l_dir_payments_ytd;
400:
401: -- Bug 3198882 : Changes End
402:
403: hr_utility.set_location('Fetching value of Voluntary Deductions balance',40);
404:
405:
406: current_and_ytd_balances (
407: p_prepaid_tag => p_prepaid_tag

Line 414: hr_utility.set_location('Fetching value of Statutory Deductions balance',50);

410: ,p_current_balance => l_voluntary_deductions_current
411: ,p_ytd_balance => l_voluntary_deductions_ytd
412: );
413:
414: hr_utility.set_location('Fetching value of Statutory Deductions balance',50);
415:
416: current_and_ytd_balances (
417: p_prepaid_tag => p_prepaid_tag
418: ,p_assignment_action_id => p_assignment_action_id

Line 428: hr_utility.set_location('Fetching value of Retro Statutory Deductions balance',52);

424: -- Bug 3290973 Starts
425: -- Fetch 'Retro Statutory Deductions' and it
426: -- to 'Statutory Deductions' Balance
427:
428: hr_utility.set_location('Fetching value of Retro Statutory Deductions balance',52);
429:
430: current_and_ytd_balances (
431: p_prepaid_tag => p_prepaid_tag
432: ,p_assignment_action_id => p_assignment_action_id

Line 460: hr_utility.set_location('Leaving '||l_procedure,55);

456: p_non_taxable_earnings_ytd := l_tot_non_taxable_earnings_ytd;
457:
458: -- Bug 3198882 : Changes End
459:
460: hr_utility.set_location('Leaving '||l_procedure,55);
461:
462: --
463: EXCEPTION
464: --

Line 466: hr_utility.set_location('Error in '||l_procedure,60);

462: --
463: EXCEPTION
464: --
465: WHEN others THEN
466: hr_utility.set_location('Error in '||l_procedure,60);
467: RAISE;
468: --
469: END balance_totals;
470:

Line 541: hr_utility.set_location('Entering '||l_procedure,10);

537: --
538: BEGIN
539: --
540: l_procedure := g_package_name || '.get_value';
541: hr_utility.set_location('Entering '||l_procedure,10);
542:
543: OPEN csr_value;
544:
545: FETCH csr_value

Line 561: hr_utility.set_location('Leaving '||l_procedure,10);

557: CLOSE csr_value;
558:
559: p_value := l_value;
560:
561: hr_utility.set_location('Leaving '||l_procedure,10);
562: --
563: EXCEPTION
564: --
565: WHEN others THEN

Line 642: hr_utility.set_location('Entering '||l_procedure,10);

638: --
639: BEGIN
640: --
641: l_procedure := g_package_name || '.get_exchange_rate';
642: hr_utility.set_location('Entering '||l_procedure,10);
643:
644: IF p_from_currency <> p_to_currency THEN
645: --
646: hr_utility.set_location('Opening cursor c_rate ', 20);

Line 646: hr_utility.set_location('Opening cursor c_rate ', 20);

642: hr_utility.set_location('Entering '||l_procedure,10);
643:
644: IF p_from_currency <> p_to_currency THEN
645: --
646: hr_utility.set_location('Opening cursor c_rate ', 20);
647:
648: OPEN c_rate;
649: FETCH c_rate INTO l_rate;
650: IF c_rate%NOTFOUND THEN

Line 657: hr_utility.set_location('Closing cursor c_rate ',30);

653: --
654: END IF;
655: CLOSE c_rate;
656:
657: hr_utility.set_location('Closing cursor c_rate ',30);
658: --
659: ELSE
660: --
661: l_rate := null;

Line 666: hr_utility.set_location('Leaving '||l_procedure,40);

662: --
663: END IF;
664: RETURN(l_rate);
665:
666: hr_utility.set_location('Leaving '||l_procedure,40);
667: --
668: EXCEPTION
669: --
670: WHEN others THEN

Line 671: hr_utility.set_location('Error in '||l_procedure,50);

667: --
668: EXCEPTION
669: --
670: WHEN others THEN
671: hr_utility.set_location('Error in '||l_procedure,50);
672: IF c_rate%ISOPEN THEN
673: CLOSE c_rate;
674: END IF;
675: RAISE;

Line 719: hr_utility.set_location('Entering '||l_procedure,10);

715: --
716: BEGIN
717: --
718: l_procedure := g_package_name || '.business_currency_code';
719: hr_utility.set_location('Entering '||l_procedure,10);
720:
721: hr_utility.set_location('Opening cursor c_currency_code',20);
722:
723: OPEN c_currency_code ;

Line 721: hr_utility.set_location('Opening cursor c_currency_code',20);

717: --
718: l_procedure := g_package_name || '.business_currency_code';
719: hr_utility.set_location('Entering '||l_procedure,10);
720:
721: hr_utility.set_location('Opening cursor c_currency_code',20);
722:
723: OPEN c_currency_code ;
724: FETCH c_currency_code INTO l_currency_code;
725: CLOSE c_currency_code;

Line 727: hr_utility.set_location('Closing cursor c_currency_code',30);

723: OPEN c_currency_code ;
724: FETCH c_currency_code INTO l_currency_code;
725: CLOSE c_currency_code;
726:
727: hr_utility.set_location('Closing cursor c_currency_code',30);
728:
729: hr_utility.set_location('Leaving '||l_procedure,40);
730:
731: RETURN l_currency_code;

Line 729: hr_utility.set_location('Leaving '||l_procedure,40);

725: CLOSE c_currency_code;
726:
727: hr_utility.set_location('Closing cursor c_currency_code',30);
728:
729: hr_utility.set_location('Leaving '||l_procedure,40);
730:
731: RETURN l_currency_code;
732: --
733: EXCEPTION

Line 736: hr_utility.set_location('Error in '||l_procedure,50);

732: --
733: EXCEPTION
734: --
735: WHEN others THEN
736: hr_utility.set_location('Error in '||l_procedure,50);
737: IF c_currency_code%ISOPEN THEN
738: CLOSE c_currency_code;
739: END IF;
740: RAISE;