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_IN_PAYSLIP_UTILS dependencies on PAY_IN_UTILS

Line 55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

51: --
52: BEGIN
53: --
54: l_procedure := g_package||'ytd_balance';
55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
56:
57: IF g_debug THEN
58: pay_in_utils.trace ('**************************************************','********************');
59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);

Line 58: pay_in_utils.trace ('******************************','');

54: l_procedure := g_package||'ytd_balance';
55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
56:
57: IF g_debug THEN
58: pay_in_utils.trace ('**************************************************','********************');
59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;

Line 59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);

55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
56:
57: IF g_debug THEN
58: pay_in_utils.trace ('**************************************************','********************');
59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;
63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');

Line 60: pay_in_utils.trace ('p_balance_name',p_balance_name);

56:
57: IF g_debug THEN
58: pay_in_utils.trace ('**************************************************','********************');
59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;
63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');
64: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 61: pay_in_utils.trace ('******************************','');

57: IF g_debug THEN
58: pay_in_utils.trace ('**************************************************','********************');
59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;
63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');
64: pay_in_utils.set_location(g_debug,l_procedure,20);
65:

Line 63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');

59: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;
63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');
64: pay_in_utils.set_location(g_debug,l_procedure,20);
65:
66: OPEN c_balance_value('_ASG_RUN');
67: FETCH c_balance_value INTO l_ytd_balance;

Line 64: pay_in_utils.set_location(g_debug,l_procedure,20);

60: pay_in_utils.trace ('p_balance_name',p_balance_name);
61: pay_in_utils.trace ('**************************************************','********************');
62: END IF;
63: pay_in_utils.trace('Fetching value of ',p_balance_name||'_ASG_RUN');
64: pay_in_utils.set_location(g_debug,l_procedure,20);
65:
66: OPEN c_balance_value('_ASG_RUN');
67: FETCH c_balance_value INTO l_ytd_balance;
68: CLOSE c_balance_value;

Line 70: pay_in_utils.trace(p_balance_name||'_ASG_RUN ',l_ytd_balance);

66: OPEN c_balance_value('_ASG_RUN');
67: FETCH c_balance_value INTO l_ytd_balance;
68: CLOSE c_balance_value;
69:
70: pay_in_utils.trace(p_balance_name||'_ASG_RUN ',l_ytd_balance);
71: pay_in_utils.set_location(g_debug,l_procedure,30);
72: p_ytd_balance := l_ytd_balance;
73:
74: IF g_debug THEN

Line 71: pay_in_utils.set_location(g_debug,l_procedure,30);

67: FETCH c_balance_value INTO l_ytd_balance;
68: CLOSE c_balance_value;
69:
70: pay_in_utils.trace(p_balance_name||'_ASG_RUN ',l_ytd_balance);
71: pay_in_utils.set_location(g_debug,l_procedure,30);
72: p_ytd_balance := l_ytd_balance;
73:
74: IF g_debug THEN
75: pay_in_utils.trace ('**************************************************','********************');

Line 75: pay_in_utils.trace ('******************************','');

71: pay_in_utils.set_location(g_debug,l_procedure,30);
72: p_ytd_balance := l_ytd_balance;
73:
74: IF g_debug THEN
75: pay_in_utils.trace ('**************************************************','********************');
76: pay_in_utils.trace ('p_ytd_balance',p_ytd_balance);
77: pay_in_utils.trace ('**************************************************','********************');
78: END IF;
79:

Line 76: pay_in_utils.trace ('p_ytd_balance',p_ytd_balance);

72: p_ytd_balance := l_ytd_balance;
73:
74: IF g_debug THEN
75: pay_in_utils.trace ('**************************************************','********************');
76: pay_in_utils.trace ('p_ytd_balance',p_ytd_balance);
77: pay_in_utils.trace ('**************************************************','********************');
78: END IF;
79:
80: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

Line 77: pay_in_utils.trace ('******************************','');

73:
74: IF g_debug THEN
75: pay_in_utils.trace ('**************************************************','********************');
76: pay_in_utils.trace ('p_ytd_balance',p_ytd_balance);
77: pay_in_utils.trace ('**************************************************','********************');
78: END IF;
79:
80: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
81: --

Line 80: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

76: pay_in_utils.trace ('p_ytd_balance',p_ytd_balance);
77: pay_in_utils.trace ('**************************************************','********************');
78: END IF;
79:
80: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
81: --
82: EXCEPTION
83: WHEN OTHERS THEN
84: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 84: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

80: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
81: --
82: EXCEPTION
83: WHEN OTHERS THEN
84: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
85: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
86: pay_in_utils.trace(l_message,l_procedure);
87:
88: IF c_balance_value%ISOPEN THEN

Line 85: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);

81: --
82: EXCEPTION
83: WHEN OTHERS THEN
84: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
85: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
86: pay_in_utils.trace(l_message,l_procedure);
87:
88: IF c_balance_value%ISOPEN THEN
89: CLOSE c_balance_value;

Line 86: pay_in_utils.trace(l_message,l_procedure);

82: EXCEPTION
83: WHEN OTHERS THEN
84: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
85: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
86: pay_in_utils.trace(l_message,l_procedure);
87:
88: IF c_balance_value%ISOPEN THEN
89: CLOSE c_balance_value;
90: END IF;

Line 154: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

150:
151: --
152: BEGIN
153: l_procedure := g_package||'balance_totals';
154: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
155:
156: -- Call procedure to get Current and YTD balances for Payment Summary Totals
157:
158: IF g_debug THEN

Line 159: pay_in_utils.trace ('******************************','');

155:
156: -- Call procedure to get Current and YTD balances for Payment Summary Totals
157:
158: IF g_debug THEN
159: pay_in_utils.trace ('**************************************************','********************');
160: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
161: pay_in_utils.trace ('**************************************************','********************');
162: END IF;
163:

Line 160: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);

156: -- Call procedure to get Current and YTD balances for Payment Summary Totals
157:
158: IF g_debug THEN
159: pay_in_utils.trace ('**************************************************','********************');
160: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
161: pay_in_utils.trace ('**************************************************','********************');
162: END IF;
163:
164: ytd_balance (

Line 161: pay_in_utils.trace ('******************************','');

157:
158: IF g_debug THEN
159: pay_in_utils.trace ('**************************************************','********************');
160: pay_in_utils.trace ('p_assignment_action_id',p_assignment_action_id);
161: pay_in_utils.trace ('**************************************************','********************');
162: END IF;
163:
164: ytd_balance (
165: p_assignment_action_id => p_assignment_action_id

Line 170: pay_in_utils.trace('l_gross_sal_less_alw_ytd ',l_gross_sal_less_alw_ytd);

166: ,p_balance_name => 'F16 Gross Salary less Allowances'
167: ,p_ytd_balance => l_gross_sal_less_alw_ytd
168: );
169:
170: pay_in_utils.trace('l_gross_sal_less_alw_ytd ',l_gross_sal_less_alw_ytd);
171: pay_in_utils.set_location(g_debug,l_procedure,20);
172:
173: ytd_balance (
174: p_assignment_action_id => p_assignment_action_id

Line 171: pay_in_utils.set_location(g_debug,l_procedure,20);

167: ,p_ytd_balance => l_gross_sal_less_alw_ytd
168: );
169:
170: pay_in_utils.trace('l_gross_sal_less_alw_ytd ',l_gross_sal_less_alw_ytd);
171: pay_in_utils.set_location(g_debug,l_procedure,20);
172:
173: ytd_balance (
174: p_assignment_action_id => p_assignment_action_id
175: ,p_balance_name => 'F16 Income Chargeable Under head Salaries'

Line 178: pay_in_utils.trace('l_gross_salary_ytd ',l_gross_salary_ytd);

174: p_assignment_action_id => p_assignment_action_id
175: ,p_balance_name => 'F16 Income Chargeable Under head Salaries'
176: ,p_ytd_balance => l_gross_salary_ytd
177: );
178: pay_in_utils.trace('l_gross_salary_ytd ',l_gross_salary_ytd);
179: pay_in_utils.set_location(g_debug,l_procedure,30);
180: l_deductions_us_16_ytd := l_gross_sal_less_alw_ytd - l_gross_salary_ytd;
181: pay_in_utils.trace('l_deductions_us_16_ytd ',l_deductions_us_16_ytd);
182: pay_in_utils.set_location(g_debug,l_procedure,40);

Line 179: pay_in_utils.set_location(g_debug,l_procedure,30);

175: ,p_balance_name => 'F16 Income Chargeable Under head Salaries'
176: ,p_ytd_balance => l_gross_salary_ytd
177: );
178: pay_in_utils.trace('l_gross_salary_ytd ',l_gross_salary_ytd);
179: pay_in_utils.set_location(g_debug,l_procedure,30);
180: l_deductions_us_16_ytd := l_gross_sal_less_alw_ytd - l_gross_salary_ytd;
181: pay_in_utils.trace('l_deductions_us_16_ytd ',l_deductions_us_16_ytd);
182: pay_in_utils.set_location(g_debug,l_procedure,40);
183:

Line 181: pay_in_utils.trace('l_deductions_us_16_ytd ',l_deductions_us_16_ytd);

177: );
178: pay_in_utils.trace('l_gross_salary_ytd ',l_gross_salary_ytd);
179: pay_in_utils.set_location(g_debug,l_procedure,30);
180: l_deductions_us_16_ytd := l_gross_sal_less_alw_ytd - l_gross_salary_ytd;
181: pay_in_utils.trace('l_deductions_us_16_ytd ',l_deductions_us_16_ytd);
182: pay_in_utils.set_location(g_debug,l_procedure,40);
183:
184: ytd_balance (
185: p_assignment_action_id => p_assignment_action_id

Line 182: pay_in_utils.set_location(g_debug,l_procedure,40);

178: pay_in_utils.trace('l_gross_salary_ytd ',l_gross_salary_ytd);
179: pay_in_utils.set_location(g_debug,l_procedure,30);
180: l_deductions_us_16_ytd := l_gross_sal_less_alw_ytd - l_gross_salary_ytd;
181: pay_in_utils.trace('l_deductions_us_16_ytd ',l_deductions_us_16_ytd);
182: pay_in_utils.set_location(g_debug,l_procedure,40);
183:
184: ytd_balance (
185: p_assignment_action_id => p_assignment_action_id
186: ,p_balance_name => 'F16 Total Chapter VI A Deductions'

Line 190: pay_in_utils.trace('l_deductions_chapter_VIa_ytd ',l_deductions_chapter_VIa_ytd);

186: ,p_balance_name => 'F16 Total Chapter VI A Deductions'
187: ,p_ytd_balance => l_deductions_chapter_VIa_ytd
188: );
189:
190: pay_in_utils.trace('l_deductions_chapter_VIa_ytd ',l_deductions_chapter_VIa_ytd);
191: pay_in_utils.set_location(g_debug,l_procedure,50);
192:
193: ytd_balance (
194: p_assignment_action_id => p_assignment_action_id

Line 191: pay_in_utils.set_location(g_debug,l_procedure,50);

187: ,p_ytd_balance => l_deductions_chapter_VIa_ytd
188: );
189:
190: pay_in_utils.trace('l_deductions_chapter_VIa_ytd ',l_deductions_chapter_VIa_ytd);
191: pay_in_utils.set_location(g_debug,l_procedure,50);
192:
193: ytd_balance (
194: p_assignment_action_id => p_assignment_action_id
195: ,p_balance_name => 'F16 Total Income'

Line 199: pay_in_utils.trace('l_total_income_ytd ',l_total_income_ytd);

195: ,p_balance_name => 'F16 Total Income'
196: ,p_ytd_balance => l_total_income_ytd
197: );
198:
199: pay_in_utils.trace('l_total_income_ytd ',l_total_income_ytd);
200: pay_in_utils.set_location(g_debug,l_procedure,60);
201:
202: ytd_balance (
203: p_assignment_action_id => p_assignment_action_id

Line 200: pay_in_utils.set_location(g_debug,l_procedure,60);

196: ,p_ytd_balance => l_total_income_ytd
197: );
198:
199: pay_in_utils.trace('l_total_income_ytd ',l_total_income_ytd);
200: pay_in_utils.set_location(g_debug,l_procedure,60);
201:
202: ytd_balance (
203: p_assignment_action_id => p_assignment_action_id
204: ,p_balance_name => 'F16 Tax on Total Income'

Line 208: pay_in_utils.trace('l_tax_on_total_income_ytd ',l_tax_on_total_income_ytd);

204: ,p_balance_name => 'F16 Tax on Total Income'
205: ,p_ytd_balance => l_tax_on_total_income_ytd
206: );
207:
208: pay_in_utils.trace('l_tax_on_total_income_ytd ',l_tax_on_total_income_ytd);
209: pay_in_utils.set_location(g_debug,l_procedure,70);
210:
211: ytd_balance (
212: p_assignment_action_id => p_assignment_action_id

Line 209: pay_in_utils.set_location(g_debug,l_procedure,70);

205: ,p_ytd_balance => l_tax_on_total_income_ytd
206: );
207:
208: pay_in_utils.trace('l_tax_on_total_income_ytd ',l_tax_on_total_income_ytd);
209: pay_in_utils.set_location(g_debug,l_procedure,70);
210:
211: ytd_balance (
212: p_assignment_action_id => p_assignment_action_id
213: ,p_balance_name => 'F16 Rebate 88'

Line 217: pay_in_utils.trace('l_rebates_sec88_ytd ',l_rebates_sec88_ytd);

213: ,p_balance_name => 'F16 Rebate 88'
214: ,p_ytd_balance => l_rebates_sec88_ytd
215: );
216:
217: pay_in_utils.trace('l_rebates_sec88_ytd ',l_rebates_sec88_ytd);
218: pay_in_utils.set_location(g_debug,l_procedure,80);
219:
220: ytd_balance (
221: p_assignment_action_id => p_assignment_action_id

Line 218: pay_in_utils.set_location(g_debug,l_procedure,80);

214: ,p_ytd_balance => l_rebates_sec88_ytd
215: );
216:
217: pay_in_utils.trace('l_rebates_sec88_ytd ',l_rebates_sec88_ytd);
218: pay_in_utils.set_location(g_debug,l_procedure,80);
219:
220: ytd_balance (
221: p_assignment_action_id => p_assignment_action_id
222: ,p_balance_name => 'F16 Rebate 88B'

Line 226: pay_in_utils.trace('l_rebates_sec88b_ytd ',l_rebates_sec88b_ytd);

222: ,p_balance_name => 'F16 Rebate 88B'
223: ,p_ytd_balance => l_rebates_sec88b_ytd
224: );
225:
226: pay_in_utils.trace('l_rebates_sec88b_ytd ',l_rebates_sec88b_ytd);
227: pay_in_utils.set_location(g_debug,l_procedure,90);
228:
229: ytd_balance (
230: p_assignment_action_id => p_assignment_action_id

Line 227: pay_in_utils.set_location(g_debug,l_procedure,90);

223: ,p_ytd_balance => l_rebates_sec88b_ytd
224: );
225:
226: pay_in_utils.trace('l_rebates_sec88b_ytd ',l_rebates_sec88b_ytd);
227: pay_in_utils.set_location(g_debug,l_procedure,90);
228:
229: ytd_balance (
230: p_assignment_action_id => p_assignment_action_id
231: ,p_balance_name => 'F16 Rebate 88C'

Line 235: pay_in_utils.trace('l_rebates_sec88c_ytd ',l_rebates_sec88c_ytd);

231: ,p_balance_name => 'F16 Rebate 88C'
232: ,p_ytd_balance => l_rebates_sec88c_ytd
233: );
234:
235: pay_in_utils.trace('l_rebates_sec88c_ytd ',l_rebates_sec88c_ytd);
236: pay_in_utils.set_location(g_debug,l_procedure,100);
237:
238: ytd_balance (
239: p_assignment_action_id => p_assignment_action_id

Line 236: pay_in_utils.set_location(g_debug,l_procedure,100);

232: ,p_ytd_balance => l_rebates_sec88c_ytd
233: );
234:
235: pay_in_utils.trace('l_rebates_sec88c_ytd ',l_rebates_sec88c_ytd);
236: pay_in_utils.set_location(g_debug,l_procedure,100);
237:
238: ytd_balance (
239: p_assignment_action_id => p_assignment_action_id
240: ,p_balance_name => 'F16 Rebate 88D'

Line 244: pay_in_utils.trace('l_rebates_sec88d_ytd ',l_rebates_sec88d_ytd);

240: ,p_balance_name => 'F16 Rebate 88D'
241: ,p_ytd_balance => l_rebates_sec88d_ytd
242: );
243:
244: pay_in_utils.trace('l_rebates_sec88d_ytd ',l_rebates_sec88d_ytd);
245: pay_in_utils.set_location(g_debug,l_procedure,110);
246: l_rebates_us_88_ytd := l_rebates_sec88_ytd + l_rebates_sec88b_ytd + l_rebates_sec88c_ytd + l_rebates_sec88d_ytd;
247: pay_in_utils.trace('l_rebates_us_88_ytd ',l_rebates_us_88_ytd);
248: pay_in_utils.set_location(g_debug,l_procedure,120);

Line 245: pay_in_utils.set_location(g_debug,l_procedure,110);

241: ,p_ytd_balance => l_rebates_sec88d_ytd
242: );
243:
244: pay_in_utils.trace('l_rebates_sec88d_ytd ',l_rebates_sec88d_ytd);
245: pay_in_utils.set_location(g_debug,l_procedure,110);
246: l_rebates_us_88_ytd := l_rebates_sec88_ytd + l_rebates_sec88b_ytd + l_rebates_sec88c_ytd + l_rebates_sec88d_ytd;
247: pay_in_utils.trace('l_rebates_us_88_ytd ',l_rebates_us_88_ytd);
248: pay_in_utils.set_location(g_debug,l_procedure,120);
249:

Line 247: pay_in_utils.trace('l_rebates_us_88_ytd ',l_rebates_us_88_ytd);

243:
244: pay_in_utils.trace('l_rebates_sec88d_ytd ',l_rebates_sec88d_ytd);
245: pay_in_utils.set_location(g_debug,l_procedure,110);
246: l_rebates_us_88_ytd := l_rebates_sec88_ytd + l_rebates_sec88b_ytd + l_rebates_sec88c_ytd + l_rebates_sec88d_ytd;
247: pay_in_utils.trace('l_rebates_us_88_ytd ',l_rebates_us_88_ytd);
248: pay_in_utils.set_location(g_debug,l_procedure,120);
249:
250: ytd_balance (
251: p_assignment_action_id => p_assignment_action_id

Line 248: pay_in_utils.set_location(g_debug,l_procedure,120);

244: pay_in_utils.trace('l_rebates_sec88d_ytd ',l_rebates_sec88d_ytd);
245: pay_in_utils.set_location(g_debug,l_procedure,110);
246: l_rebates_us_88_ytd := l_rebates_sec88_ytd + l_rebates_sec88b_ytd + l_rebates_sec88c_ytd + l_rebates_sec88d_ytd;
247: pay_in_utils.trace('l_rebates_us_88_ytd ',l_rebates_us_88_ytd);
248: pay_in_utils.set_location(g_debug,l_procedure,120);
249:
250: ytd_balance (
251: p_assignment_action_id => p_assignment_action_id
252: ,p_balance_name => 'F16 TDS'

Line 255: pay_in_utils.trace('l_income_tax_ytd ',l_income_tax_ytd);

251: p_assignment_action_id => p_assignment_action_id
252: ,p_balance_name => 'F16 TDS'
253: ,p_ytd_balance => l_income_tax_ytd
254: );
255: pay_in_utils.trace('l_income_tax_ytd ',l_income_tax_ytd);
256: pay_in_utils.set_location(g_debug,l_procedure,130);
257:
258: p_gross_salary_les_alw_ytd := l_gross_sal_less_alw_ytd;
259: p_deductions_us_16_ytd := l_deductions_us_16_ytd;

Line 256: pay_in_utils.set_location(g_debug,l_procedure,130);

252: ,p_balance_name => 'F16 TDS'
253: ,p_ytd_balance => l_income_tax_ytd
254: );
255: pay_in_utils.trace('l_income_tax_ytd ',l_income_tax_ytd);
256: pay_in_utils.set_location(g_debug,l_procedure,130);
257:
258: p_gross_salary_les_alw_ytd := l_gross_sal_less_alw_ytd;
259: p_deductions_us_16_ytd := l_deductions_us_16_ytd;
260: p_gross_salary_ytd := l_gross_salary_ytd;

Line 268: pay_in_utils.trace('******************************','');

264: p_rebates_us_88_ytd := l_rebates_us_88_ytd;
265: p_income_tax_ytd := l_income_tax_ytd;
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);

Line 269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);

265: p_income_tax_ytd := l_income_tax_ytd;
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);

Line 270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);

266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);

Line 271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);

267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);

Line 272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);

268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);

Line 273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);

269: pay_in_utils.trace('p_gross_salary_les_alw_ytd',p_gross_salary_les_alw_ytd);
270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');

Line 274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);

270: pay_in_utils.trace('p_deductions_us_16_ytd',p_deductions_us_16_ytd);
271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');
278: END IF;

Line 275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);

271: pay_in_utils.trace('p_gross_salary_ytd',p_gross_salary_ytd);
272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');
278: END IF;
279:

Line 276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);

272: pay_in_utils.trace('p_deductions_chapter_VIa_ytd',p_deductions_chapter_VIa_ytd);
273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');
278: END IF;
279:
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,140);

Line 277: pay_in_utils.trace('******************************','');

273: pay_in_utils.trace('p_total_income_ytd',p_total_income_ytd);
274: pay_in_utils.trace('p_tax_on_total_income_ytd',p_tax_on_total_income_ytd);
275: pay_in_utils.trace('p_rebates_us_88_ytd',p_rebates_us_88_ytd);
276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');
278: END IF;
279:
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,140);
281:

Line 280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,140);

276: pay_in_utils.trace('p_income_tax_ytd',p_income_tax_ytd);
277: pay_in_utils.trace('**************************************************','********************');
278: END IF;
279:
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,140);
281:
282: --
283: END balance_totals;
284:

Line 352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

348: --
349: BEGIN
350: --
351: l_procedure := g_package || 'get_exchange_rate';
352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
353:
354:
355: IF g_debug THEN
356: pay_in_utils.trace ('**************************************************','********************');

Line 356: pay_in_utils.trace ('******************************','');

352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
353:
354:
355: IF g_debug THEN
356: pay_in_utils.trace ('**************************************************','********************');
357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);

Line 357: pay_in_utils.trace ('p_from_currency',p_from_currency);

353:
354:
355: IF g_debug THEN
356: pay_in_utils.trace ('**************************************************','********************');
357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);
361: pay_in_utils.trace ('**************************************************','********************');

Line 358: pay_in_utils.trace ('p_to_currency',p_to_currency);

354:
355: IF g_debug THEN
356: pay_in_utils.trace ('**************************************************','********************');
357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);
361: pay_in_utils.trace ('**************************************************','********************');
362: END IF;

Line 359: pay_in_utils.trace ('p_eff_date',p_eff_date);

355: IF g_debug THEN
356: pay_in_utils.trace ('**************************************************','********************');
357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);
361: pay_in_utils.trace ('**************************************************','********************');
362: END IF;
363:

Line 360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);

356: pay_in_utils.trace ('**************************************************','********************');
357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);
361: pay_in_utils.trace ('**************************************************','********************');
362: END IF;
363:
364: IF p_from_currency <> p_to_currency THEN

Line 361: pay_in_utils.trace ('******************************','');

357: pay_in_utils.trace ('p_from_currency',p_from_currency);
358: pay_in_utils.trace ('p_to_currency',p_to_currency);
359: pay_in_utils.trace ('p_eff_date',p_eff_date);
360: pay_in_utils.trace ('p_business_group_id',p_business_group_id);
361: pay_in_utils.trace ('**************************************************','********************');
362: END IF;
363:
364: IF p_from_currency <> p_to_currency THEN
365: --

Line 381: pay_in_utils.trace ('******************************','');

377: --
378: l_rate := null;
379: --
380: END IF;
381: pay_in_utils.trace ('**************************************************','********************');
382: pay_in_utils.trace('l_rate',l_rate);
383: pay_in_utils.trace ('**************************************************','********************');
384: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
385: RETURN(l_rate);

Line 382: pay_in_utils.trace('l_rate',l_rate);

378: l_rate := null;
379: --
380: END IF;
381: pay_in_utils.trace ('**************************************************','********************');
382: pay_in_utils.trace('l_rate',l_rate);
383: pay_in_utils.trace ('**************************************************','********************');
384: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
385: RETURN(l_rate);
386: --

Line 383: pay_in_utils.trace ('******************************','');

379: --
380: END IF;
381: pay_in_utils.trace ('**************************************************','********************');
382: pay_in_utils.trace('l_rate',l_rate);
383: pay_in_utils.trace ('**************************************************','********************');
384: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
385: RETURN(l_rate);
386: --
387: EXCEPTION

Line 384: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

380: END IF;
381: pay_in_utils.trace ('**************************************************','********************');
382: pay_in_utils.trace('l_rate',l_rate);
383: pay_in_utils.trace ('**************************************************','********************');
384: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
385: RETURN(l_rate);
386: --
387: EXCEPTION
388: WHEN OTHERS THEN

Line 389: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

385: RETURN(l_rate);
386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
390: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
391: pay_in_utils.trace(l_message,l_procedure);
392:
393: IF c_rate%ISOPEN THEN

Line 390: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);

386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
390: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
391: pay_in_utils.trace(l_message,l_procedure);
392:
393: IF c_rate%ISOPEN THEN
394: CLOSE c_rate;

Line 391: pay_in_utils.trace(l_message,l_procedure);

387: EXCEPTION
388: WHEN OTHERS THEN
389: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
390: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
391: pay_in_utils.trace(l_message,l_procedure);
392:
393: IF c_rate%ISOPEN THEN
394: CLOSE c_rate;
395: END IF;