DBA Data[Home] [Help]

APPS.PAY_AU_BAL_UPLOAD dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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