DBA Data[Home] [Help]

APPS.PAY_AC_UTILITY dependencies on HR_UTILITY

Line 286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');

282: ln_value NUMBER;
283:
284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);

Line 287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);

283:
284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

Line 288: hr_utility.trace('p_dimension_name: '||p_dimension_name);

284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);

Line 289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);

285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:

Line 290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);

286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id

Line 291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id
295: ,p_dimension_name

Line 292: hr_utility.trace('p_date_paid: '||p_date_paid);

288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id
295: ,p_dimension_name
296: ,p_bus_grp_id

Line 299: hr_utility.trace('ln_defined_balance_id: '||ln_defined_balance_id);

295: ,p_dimension_name
296: ,p_bus_grp_id
297: ,p_legislation_cd);
298:
299: hr_utility.trace('ln_defined_balance_id: '||ln_defined_balance_id);
300:
301: if ln_defined_balance_id <> 0 then
302: ln_value := pay_balance_pkg.get_value
303: (p_defined_balance_id => ln_defined_balance_id

Line 314: hr_utility.trace('ln_value: '||ln_value);

310: else
311: ln_value := NULL;
312: end if;
313:
314: hr_utility.trace('ln_value: '||ln_value);
315: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type ID');
316:
317: return ln_value;
318:

Line 315: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type ID');

311: ln_value := NULL;
312: end if;
313:
314: hr_utility.trace('ln_value: '||ln_value);
315: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type ID');
316:
317: return ln_value;
318:
319: END get_value;

Line 334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');

330: ln_balance_type_id NUMBER;
331: ln_value NUMBER;
332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);

Line 335: hr_utility.trace('p_balance_name: '||p_balance_name);

331: ln_value NUMBER;
332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

Line 336: hr_utility.trace('p_dimension_name: '||p_dimension_name);

332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);

Line 337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);

333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:

Line 338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);

334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name

Line 339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id

Line 340: hr_utility.trace('p_date_paid: '||p_date_paid);

336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id
344: , p_legislation_cd);

Line 346: hr_utility.trace('ln_balance_type_id: '||ln_balance_type_id);

342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id
344: , p_legislation_cd);
345:
346: hr_utility.trace('ln_balance_type_id: '||ln_balance_type_id);
347:
348: ln_value := get_value(p_balance_type_id => ln_balance_type_id
349: ,p_dimension_name => p_dimension_name
350: ,p_bus_grp_id => p_bus_grp_id

Line 356: hr_utility.trace('ln_value: '||ln_value);

352: ,p_asg_act_id => p_asg_act_id
353: ,p_tax_unit_id => p_tax_unit_id
354: ,p_date_paid => p_date_paid);
355:
356: hr_utility.trace('ln_value: '||ln_value);
357: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type Name');
358:
359: return ln_value;
360:

Line 357: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type Name');

353: ,p_tax_unit_id => p_tax_unit_id
354: ,p_date_paid => p_date_paid);
355:
356: hr_utility.trace('ln_value: '||ln_value);
357: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type Name');
358:
359: return ln_value;
360:
361: END get_value;

Line 399: hr_utility.set_location('range_person_on',10);

395: lv_action_param_val varchar2(30);
396: lv_report_param_val varchar2(30);
397:
398: BEGIN
399: hr_utility.set_location('range_person_on',10);
400:
401: open csr_action_parameter;
402: fetch csr_action_parameter into lv_action_param_val;
403: close csr_action_parameter;

Line 405: hr_utility.set_location('range_person_on',20);

401: open csr_action_parameter;
402: fetch csr_action_parameter into lv_action_param_val;
403: close csr_action_parameter;
404:
405: hr_utility.set_location('range_person_on',20);
406: open csr_range_format_param;
407: fetch csr_range_format_param into lv_report_param_val;
408: close csr_range_format_param;
409:

Line 410: hr_utility.set_location('range_person_on',30);

406: open csr_range_format_param;
407: fetch csr_range_format_param into lv_report_param_val;
408: close csr_range_format_param;
409:
410: hr_utility.set_location('range_person_on',30);
411:
412: IF nvl(lv_action_param_val,'N') = 'Y' AND
413: nvl(lv_report_param_val,'N') = 'Y' THEN
414: lb_return := TRUE;

Line 415: hr_utility.trace('Range Person = True');

411:
412: IF nvl(lv_action_param_val,'N') = 'Y' AND
413: nvl(lv_report_param_val,'N') = 'Y' THEN
414: lb_return := TRUE;
415: hr_utility.trace('Range Person = True');
416: ELSE
417: lb_return := FALSE;
418: END IF;
419:

Line 503: hr_utility.trace('BLOB contents: -');

499: lr_buf RAW(2000);
500: BEGIN
501: ln_offset := 1;
502: ln_amount := 2000;
503: hr_utility.trace('BLOB contents: -');
504: LOOP
505: dbms_lob.read(
506: p_blob,
507: ln_amount,

Line 512: hr_utility.trace(utl_raw.cast_to_varchar2(lr_buf));

508: ln_offset,
509: lr_buf);
510: ln_amount := 2000;
511: ln_offset := ln_offset + ln_amount;
512: hr_utility.trace(utl_raw.cast_to_varchar2(lr_buf));
513: END LOOP;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: hr_utility.trace('BLOB contents end.');

Line 516: hr_utility.trace('BLOB contents end.');

512: hr_utility.trace(utl_raw.cast_to_varchar2(lr_buf));
513: END LOOP;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: hr_utility.trace('BLOB contents end.');
517: END print_lob;
518:
519: end pay_ac_utility;