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

Line 64: hr_utility.set_location('Entering: '||l_proc_name, 5);

60:
61: l_proc_name constant varchar2(150) := g_package ||'Get_us_Balance_Value';
62:
63: begin
64: hr_utility.set_location('Entering: '||l_proc_name, 5);
65:
66: --
67: open c_tax_id(c_assignment_id => p_assignment_id
68: ,c_effective_date => p_effective_date);

Line 117: hr_utility.set_location('Leaving: '||l_proc_name, 80);

113: ,p_assignment_id
114: ,p_effective_date);
115:
116:
117: hr_utility.set_location('Leaving: '||l_proc_name, 80);
118: return l_balance_amount;
119: exception
120: when others then
121: hr_utility.set_location('Leaving: '||l_proc_name, 90);

Line 121: hr_utility.set_location('Leaving: '||l_proc_name, 90);

117: hr_utility.set_location('Leaving: '||l_proc_name, 80);
118: return l_balance_amount;
119: exception
120: when others then
121: hr_utility.set_location('Leaving: '||l_proc_name, 90);
122: l_balance_amount := null ;
123: raise;
124: end Get_us_Balance_Value;
125:

Line 140: hr_utility.set_location('Entering: '||l_proc_name, 5);

136: l_gre_id number;
137: l_proc_name constant varchar2(150) := g_package ||'Get_fn_Balance_Value';
138:
139: begin
140: hr_utility.set_location('Entering: '||l_proc_name, 5);
141:
142: --
143: if p_legislation_code = 'FI' then
144:

Line 205: hr_utility.set_location('Leaving: '||l_proc_name, 80);

201: ,p_assignment_id
202: ,p_effective_date);
203:
204:
205: hr_utility.set_location('Leaving: '||l_proc_name, 80);
206: return l_balance_amount;
207: exception
208: when others then
209: hr_utility.set_location('Leaving: '||l_proc_name, 90);

Line 209: hr_utility.set_location('Leaving: '||l_proc_name, 90);

205: hr_utility.set_location('Leaving: '||l_proc_name, 80);
206: return l_balance_amount;
207: exception
208: when others then
209: hr_utility.set_location('Leaving: '||l_proc_name, 90);
210: l_balance_amount := null ;
211: raise;
212: end Get_fn_Balance_Value;
213:

Line 232: hr_utility.set_location('Entering: '||l_proc_name, 5);

228:
229:
230: begin
231:
232: hr_utility.set_location('Entering: '||l_proc_name, 5);
233:
234: if p_legislation_code in ( 'US','CA','AU','CN','DK','HK','IN','KW','SA','SG','AE','FR') then
235: l_balance_amount := Get_US_Balance_Value
236: (p_business_group_id => p_business_group_id

Line 260: hr_utility.set_location('Leaving: '||l_proc_name, 80);

256: ,p_assignment_id
257: ,p_effective_date);
258: end if ;
259:
260: hr_utility.set_location('Leaving: '||l_proc_name, 80);
261: return l_balance_amount;
262:
263: exception
264: when others then

Line 265: hr_utility.set_location('Leaving: '||l_proc_name, 90);

261: return l_balance_amount;
262:
263: exception
264: when others then
265: hr_utility.set_location('Leaving: '||l_proc_name, 90);
266: l_balance_amount := null;
267: return l_balance_amount ;
268: end Get_Balance_Value ;
269:

Line 283: hr_utility.set_location('Entering: '||l_proc, 5);

279: l_proc varchar2(75) ;
280: BEGIN
281:
282: l_proc := g_package ||'sort_payroll_events';
283: hr_utility.set_location('Entering: '||l_proc, 5);
284: -- nullify the global table
285: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab ;
286: --intiali
287: l_pay_events_tab := p_pay_events_tab;

Line 289: hr_utility.set_location('Before Looping ', 10);

285: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab ;
286: --intiali
287: l_pay_events_tab := p_pay_events_tab;
288:
289: hr_utility.set_location('Before Looping ', 10);
290: hr_utility.set_location('Count:'||to_char(l_pay_events_tab.COUNT), 10 );
291:
292: IF (l_pay_events_tab.COUNT > 0) THEN
293:

Line 290: hr_utility.set_location('Count:'||to_char(l_pay_events_tab.COUNT), 10 );

286: --intiali
287: l_pay_events_tab := p_pay_events_tab;
288:
289: hr_utility.set_location('Before Looping ', 10);
290: hr_utility.set_location('Count:'||to_char(l_pay_events_tab.COUNT), 10 );
291:
292: IF (l_pay_events_tab.COUNT > 0) THEN
293:
294: --

Line 299: hr_utility.trace('Inside Loop1');

295: -- Bubble sort the events by effective_date
296: --
297: FOR i IN l_pay_events_tab.FIRST .. l_pay_events_tab.LAST
298: LOOP
299: hr_utility.trace('Inside Loop1');
300: l_next_event_date := null ;
301: FOR j IN l_pay_events_tab.FIRST + i .. l_pay_events_tab.LAST
302: LOOP
303: hr_utility.trace('Inside Loop2');

Line 303: hr_utility.trace('Inside Loop2');

299: hr_utility.trace('Inside Loop1');
300: l_next_event_date := null ;
301: FOR j IN l_pay_events_tab.FIRST + i .. l_pay_events_tab.LAST
302: LOOP
303: hr_utility.trace('Inside Loop2');
304: IF (l_pay_events_tab (i).effective_date > l_pay_events_tab (j).effective_date)
305: THEN
306: hr_utility.trace('Inside IF');
307: l_sortrec := l_pay_events_tab (i);

Line 306: hr_utility.trace('Inside IF');

302: LOOP
303: hr_utility.trace('Inside Loop2');
304: IF (l_pay_events_tab (i).effective_date > l_pay_events_tab (j).effective_date)
305: THEN
306: hr_utility.trace('Inside IF');
307: l_sortrec := l_pay_events_tab (i);
308: l_pay_events_tab (i) := l_pay_events_tab (j);
309: l_pay_events_tab (j) := l_sortrec;
310: END IF;

Line 316: hr_utility.set_location('previous date ' || l_next_event_date , 99 ) ;

312: l_next_event_date := l_pay_events_tab(i).effective_date ;
313: -- update the previous rows next event start date
314: if l_next_event_date is not null and i > 1 and l_pay_events_tab.exists(i-1) then
315: l_pay_events_tab(i-1).next_evt_start_date := l_next_event_date ;
316: hr_utility.set_location('previous date ' || l_next_event_date , 99 ) ;
317: end if ;
318:
319: END LOOP;
320:

Line 321: hr_utility.set_location('Finished Looping', 10 );

317: end if ;
318:
319: END LOOP;
320:
321: hr_utility.set_location('Finished Looping', 10 );
322: --
323: END IF;
324:
325: -- Assign back the sorted collection

Line 328: hr_utility.set_location('Leaving: '||l_proc, 80);

324:
325: -- Assign back the sorted collection
326: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab;
327:
328: hr_utility.set_location('Leaving: '||l_proc, 80);
329: EXCEPTION
330: WHEN OTHERS THEN
331: ben_ext_person.g_pay_proc_evt_tab := p_pay_events_tab ;
332: hr_utility.set_location('error ' || substr(sqlerrm,1,200) , 99 ) ;

Line 332: hr_utility.set_location('error ' || substr(sqlerrm,1,200) , 99 ) ;

328: hr_utility.set_location('Leaving: '||l_proc, 80);
329: EXCEPTION
330: WHEN OTHERS THEN
331: ben_ext_person.g_pay_proc_evt_tab := p_pay_events_tab ;
332: hr_utility.set_location('error ' || substr(sqlerrm,1,200) , 99 ) ;
333: RAISE;
334: END;
335:
336: