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.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 238: hr_utility.set_location('Entering '||l_procedure,10);

234: --
235: BEGIN
236: --
237: l_procedure := g_package_name || '.balance_totals';
238: hr_utility.set_location('Entering '||l_procedure,10);
239:
240: -- Call procedure to get Current and YTD balances for Payment Summary Totals
241:
242: hr_utility.set_location('Fetching value of Taxable Earnings balance',20);

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

238: hr_utility.set_location('Entering '||l_procedure,10);
239:
240: -- Call procedure to get Current and YTD balances for Payment Summary Totals
241:
242: hr_utility.set_location('Fetching value of Taxable Earnings balance',20);
243:
244: current_and_ytd_balances (
245: p_prepaid_tag => p_prepaid_tag
246: ,p_assignment_action_id => p_assignment_action_id

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

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

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

265:
266: -- Bug 4303538 starts
267: -- The following balance should be added up to 'Taxable Earnings' Balance
268: --
269: hr_utility.set_location('Fetching value of Annual Bonus balance',24);
270:
271: current_and_ytd_balances (
272: p_prepaid_tag => p_prepaid_tag
273: ,p_assignment_action_id => p_assignment_action_id

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

276: ,p_ytd_balance => l_annual_bonus_ytd
277: );
278: -- Bug 4303538 ends
279:
280: hr_utility.set_location('Fetching value of Special Payments Separate balance',25);
281:
282: current_and_ytd_balances (
283: p_prepaid_tag => p_prepaid_tag
284: ,p_assignment_action_id => p_assignment_action_id

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

287: ,p_ytd_balance => l_spec_separate_ytd
288: );
289:
290:
291: hr_utility.set_location('Fetching value of Special Payments Spread balance',27);
292:
293: current_and_ytd_balances (
294: p_prepaid_tag => p_prepaid_tag
295: ,p_assignment_action_id => p_assignment_action_id

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

301: -- Bug 3290973 Starts
302: -- Fetch 'Retro Taxable Earnings' and 'Retro Special Payments' Balances and them
303: -- to 'Taxable Earnings' Balance
304:
305: hr_utility.set_location('Fetching value of Retro Taxable Earnings balance',28);
306:
307: current_and_ytd_balances (
308: p_prepaid_tag => p_prepaid_tag
309: ,p_assignment_action_id => p_assignment_action_id

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

311: ,p_current_balance => l_retro_tax_earnings_current
312: ,p_ytd_balance => l_retro_tax_earnings_ytd
313: );
314:
315: hr_utility.set_location('Fetching value of Retro Special Payments 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 328: hr_utility.set_location('Fetching value of Retro Annual Bonus balance',28);

324:
325: -- Bug 4303538 starts
326: -- The following balance should be added up to 'Taxable Earnings' Balance
327: --
328: hr_utility.set_location('Fetching value of Retro Annual Bonus balance',28);
329:
330: current_and_ytd_balances (
331: p_prepaid_tag => p_prepaid_tag
332: ,p_assignment_action_id => p_assignment_action_id

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

335: ,p_ytd_balance => l_retro_ann_bonus_ytd
336: );
337: -- Bug 4303538 ends
338:
339: hr_utility.set_location('Fetching value of Variable Yearly Earnings balance',28);
340:
341: --
342: -- Bug 3812288 Changes start
343: --

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

348: ,p_current_balance => l_var_yrly_pay_current
349: ,p_ytd_balance => l_var_yrly_pay_ytd
350: );
351:
352: hr_utility.set_location('Fetching value of Retro Variable yearly Earnings balance',28);
353:
354: current_and_ytd_balances (
355: p_prepaid_tag => p_prepaid_tag
356: ,p_assignment_action_id => p_assignment_action_id

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

381: -- Bug 3290973 ends
382:
383: -- Bug 3116630 ends
384:
385: hr_utility.set_location('Fetching value of Non Taxable Earnings balance',30);
386:
387: current_and_ytd_balances (
388: p_prepaid_tag => p_prepaid_tag
389: ,p_assignment_action_id => p_assignment_action_id

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

395: -- Bug 3198882 : Changes Start
396: -- Included the 'Direct Payments' PTD and YTD balance values in 'Non Taxable Earnings'
397: -- PTD and YTD balances for archival
398:
399: hr_utility.set_location('Fetching Value of Direct payments balance',35);
400:
401: current_and_ytd_balances (
402: p_prepaid_tag => p_prepaid_tag
403: ,p_assignment_action_id => p_assignment_action_id

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

412: l_tot_non_taxable_earnings_ytd := l_non_taxable_earnings_ytd + l_dir_payments_ytd;
413:
414: -- Bug 3198882 : Changes End
415:
416: hr_utility.set_location('Fetching value of Voluntary Deductions balance',40);
417:
418:
419: current_and_ytd_balances (
420: p_prepaid_tag => p_prepaid_tag

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

423: ,p_current_balance => l_voluntary_deductions_current
424: ,p_ytd_balance => l_voluntary_deductions_ytd
425: );
426:
427: hr_utility.set_location('Fetching value of Statutory Deductions balance',50);
428:
429: current_and_ytd_balances (
430: p_prepaid_tag => p_prepaid_tag
431: ,p_assignment_action_id => p_assignment_action_id

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

437: -- Bug 3290973 Starts
438: -- Fetch 'Retro Statutory Deductions' and it
439: -- to 'Statutory Deductions' Balance
440:
441: hr_utility.set_location('Fetching value of Retro Statutory Deductions balance',52);
442:
443: current_and_ytd_balances (
444: p_prepaid_tag => p_prepaid_tag
445: ,p_assignment_action_id => p_assignment_action_id

Line 456: hr_utility.set_location('Fetching value of Pre Tax Non Statutory Deductions balance',53);

452:
453: l_tot_stat_ded_current := l_statutory_deductions_current + l_retro_stat_ded_current;
454: l_tot_stat_ded_ytd := l_statutory_deductions_ytd + l_retro_stat_ded_ytd;
455:
456: hr_utility.set_location('Fetching value of Pre Tax Non Statutory Deductions balance',53);
457:
458: current_and_ytd_balances (
459: p_prepaid_tag => p_prepaid_tag
460: ,p_assignment_action_id => p_assignment_action_id

Line 467: hr_utility.set_location('Fetching value of Retro Pre Tax Non Statutory Deductions balance',54);

463: ,p_ytd_balance => l_pre_tax_deductions_ytd
464: );
465:
466:
467: hr_utility.set_location('Fetching value of Retro Pre Tax Non Statutory Deductions balance',54);
468:
469: current_and_ytd_balances (
470: p_prepaid_tag => p_prepaid_tag
471: ,p_assignment_action_id => p_assignment_action_id

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

498: p_non_taxable_earnings_ytd := l_tot_non_taxable_earnings_ytd;
499:
500: -- Bug 3198882 : Changes End
501:
502: hr_utility.set_location('Leaving '||l_procedure,55);
503:
504: --
505: EXCEPTION
506: --

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

504: --
505: EXCEPTION
506: --
507: WHEN others THEN
508: hr_utility.set_location('Error in '||l_procedure,60);
509: RAISE;
510: --
511: END balance_totals;
512:

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

582: --
583: BEGIN
584: --
585: l_procedure := g_package_name || '.get_value';
586: hr_utility.set_location('Entering '||l_procedure,10);
587:
588: OPEN csr_value;
589:
590: FETCH csr_value

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

602: CLOSE csr_value;
603:
604: p_value := l_value;
605:
606: hr_utility.set_location('Leaving '||l_procedure,10);
607: --
608: EXCEPTION
609: --
610: WHEN others THEN

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

683: --
684: BEGIN
685: --
686: l_procedure := g_package_name || '.get_exchange_rate';
687: hr_utility.set_location('Entering '||l_procedure,10);
688:
689: IF p_from_currency <> p_to_currency THEN
690: --
691: hr_utility.set_location('Opening cursor c_rate ', 20);

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

687: hr_utility.set_location('Entering '||l_procedure,10);
688:
689: IF p_from_currency <> p_to_currency THEN
690: --
691: hr_utility.set_location('Opening cursor c_rate ', 20);
692:
693: OPEN c_rate;
694: FETCH c_rate INTO l_rate;
695: IF c_rate%NOTFOUND THEN

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

698: --
699: END IF;
700: CLOSE c_rate;
701:
702: hr_utility.set_location('Closing cursor c_rate ',30);
703: --
704: ELSE
705: --
706: l_rate := null;

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

707: --
708: END IF;
709: RETURN(l_rate);
710:
711: hr_utility.set_location('Leaving '||l_procedure,40);
712: --
713: EXCEPTION
714: --
715: WHEN others THEN

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

712: --
713: EXCEPTION
714: --
715: WHEN others THEN
716: hr_utility.set_location('Error in '||l_procedure,50);
717: IF c_rate%ISOPEN THEN
718: CLOSE c_rate;
719: END IF;
720: RAISE;

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

760: --
761: BEGIN
762: --
763: l_procedure := g_package_name || '.business_currency_code';
764: hr_utility.set_location('Entering '||l_procedure,10);
765:
766: hr_utility.set_location('Opening cursor c_currency_code',20);
767:
768: OPEN c_currency_code ;

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

762: --
763: l_procedure := g_package_name || '.business_currency_code';
764: hr_utility.set_location('Entering '||l_procedure,10);
765:
766: hr_utility.set_location('Opening cursor c_currency_code',20);
767:
768: OPEN c_currency_code ;
769: FETCH c_currency_code INTO l_currency_code;
770: CLOSE c_currency_code;

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

768: OPEN c_currency_code ;
769: FETCH c_currency_code INTO l_currency_code;
770: CLOSE c_currency_code;
771:
772: hr_utility.set_location('Closing cursor c_currency_code',30);
773:
774: hr_utility.set_location('Leaving '||l_procedure,40);
775:
776: RETURN l_currency_code;

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

770: CLOSE c_currency_code;
771:
772: hr_utility.set_location('Closing cursor c_currency_code',30);
773:
774: hr_utility.set_location('Leaving '||l_procedure,40);
775:
776: RETURN l_currency_code;
777: --
778: EXCEPTION

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

777: --
778: EXCEPTION
779: --
780: WHEN others THEN
781: hr_utility.set_location('Error in '||l_procedure,50);
782: IF c_currency_code%ISOPEN THEN
783: CLOSE c_currency_code;
784: END IF;
785: RAISE;