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_AU_BAL_UPLOAD dependencies on HR_UTILITY

Line 99: hr_utility.trace('In: ' || l_fn_name) ;

95:
96:
97: begin
98:
99: hr_utility.trace('In: ' || l_fn_name) ;
100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;

Line 100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;

96:
97: begin
98:
99: hr_utility.trace('In: ' || l_fn_name) ;
100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
104:

Line 101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;

97: begin
98:
99: hr_utility.trace('In: ' || l_fn_name) ;
100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
104:
105: -- get assignment details

Line 102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;

98:
99: hr_utility.trace('In: ' || l_fn_name) ;
100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
104:
105: -- get assignment details
106: open c_assignment(p_assignment_id, p_upload_date);

Line 103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;

99: hr_utility.trace('In: ' || l_fn_name) ;
100: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
101: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
102: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
103: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
104:
105: -- get assignment details
106: open c_assignment(p_assignment_id, p_upload_date);
107: fetch c_assignment

Line 232: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;

228: if l_expiry_date is null then
229: raise e_bad_expiry_date ;
230: end if;
231:
232: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
233: hr_utility.trace('Out: ' || l_fn_name) ;
234: return l_expiry_date;
235:
236: exception

Line 233: hr_utility.trace('Out: ' || l_fn_name) ;

229: raise e_bad_expiry_date ;
230: end if;
231:
232: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
233: hr_utility.trace('Out: ' || l_fn_name) ;
234: return l_expiry_date;
235:
236: exception
237: -- when e_bad_expiry_date then

Line 242: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;

238: -- l_expiry_date := g_end_of_time;
239: -- return l_expiry_date;
240: when others then
241: l_expiry_date := g_end_of_time;
242: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
243: hr_utility.trace('Out: ' || l_fn_name) ;
244: return l_expiry_date;
245:
246: end expiry_date;

Line 243: hr_utility.trace('Out: ' || l_fn_name) ;

239: -- return l_expiry_date;
240: when others then
241: l_expiry_date := g_end_of_time;
242: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
243: hr_utility.trace('Out: ' || l_fn_name) ;
244: return l_expiry_date;
245:
246: end expiry_date;
247:

Line 267: hr_utility.trace('Entering '||l_proc);

263: return number is
264: l_proc constant varchar2(72) := g_package||'is_supported';
265: begin
266:
267: hr_utility.trace('Entering '||l_proc);
268:
269: -- see if the dimension is supported.
270:
271: /* Bug 4516174 - Added support for LE level dimensions */

Line 293: hr_utility.trace('Exiting '||l_proc);

289: ,'_ASG_LE_TD'
290: ,'_ASG_LE_YTD'
291: )
292: then
293: hr_utility.trace('Exiting '||l_proc);
294: return 1;
295: else
296: hr_utility.trace('Exiting '||l_proc);
297: return 0;

Line 296: hr_utility.trace('Exiting '||l_proc);

292: then
293: hr_utility.trace('Exiting '||l_proc);
294: return 1;
295: else
296: hr_utility.trace('Exiting '||l_proc);
297: return 0;
298: end if;
299:
300: end is_supported;

Line 398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));

394: CLOSE csr_get_tested_adjustments;
395:
396: -- Does the balance adjustment effect the new balance
397:
398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));

Line 399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));

395:
396: -- Does the balance adjustment effect the new balance
397:
398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
403:

Line 400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));

396: -- Does the balance adjustment effect the new balance
397:
398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
403:
404:

Line 401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));

397:
398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
403:
404:
405: OPEN csr_is_included(p_balance_type_id

Line 402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));

398: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
399: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
400: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
401: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
402: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
403:
404:
405: OPEN csr_is_included(p_balance_type_id
406: ,l_tax_unit_id

Line 456: hr_utility.trace('Entering '||g_package||'validate_batch_lines');

452:
453: procedure validate_batch_lines( p_batch_id number ) is
454: begin
455:
456: hr_utility.trace('Entering '||g_package||'validate_batch_lines');
457:
458: hr_utility.trace('Exiting '||g_package||'validate_batch_lines');
459:
460: end validate_batch_lines;

Line 458: hr_utility.trace('Exiting '||g_package||'validate_batch_lines');

454: begin
455:
456: hr_utility.trace('Entering '||g_package||'validate_batch_lines');
457:
458: hr_utility.trace('Exiting '||g_package||'validate_batch_lines');
459:
460: end validate_batch_lines;
461:
462: end pay_au_bal_upload;