DBA Data[Home] [Help]

APPS.PAY_CN_BAL_UPLOAD dependencies on HR_UTILITY

Line 383: hr_utility.trace('Entering pay_cn_bal_upload.is_supported');

379: l_dimension_id NUMBER;
380: --
381: BEGIN
382: --
383: hr_utility.trace('Entering pay_cn_bal_upload.is_supported');
384: --
385: -- See if the dimension is supported.
386: --
387: OPEN csr_dimension (p_dimension_name);

Line 398: hr_utility.trace('Exiting pay_cn_bal_upload.is_supported');

394: CLOSE csr_dimension;
395: RETURN (1); -- denotes TRUE
396: END IF;
397: --
398: hr_utility.trace('Exiting pay_cn_bal_upload.is_supported');
399: --
400: EXCEPTION
401: WHEN others THEN
402: CLOSE csr_dimension;

Line 506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');

502: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
503: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
504:
505: BEGIN
506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');
507:
508: OPEN csr_get_tax_unit(p_batch_line_id);
509: FETCH csr_get_tax_unit
510: INTO l_tax_unit_id;

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

517: CLOSE csr_get_tested_adjustments;
518:
519: -- Does the balance adjustment effect the new balance ?
520:
521: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
522: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
523: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
524: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
525: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));

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

518:
519: -- Does the balance adjustment effect the new balance ?
520:
521: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
522: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
523: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
524: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
525: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
526:

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

519: -- Does the balance adjustment effect the new balance ?
520:
521: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
522: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
523: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
524: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
525: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
526:
527: OPEN csr_is_included(p_balance_type_id

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

520:
521: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
522: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
523: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
524: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
525: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
526:
527: OPEN csr_is_included(p_balance_type_id
528: ,l_tax_unit_id

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

521: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
522: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
523: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
524: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
525: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
526:
527: OPEN csr_is_included(p_balance_type_id
528: ,l_tax_unit_id
529: ,p_original_entry_id

Line 537: hr_utility.trace('Exiting pay_cn_bal_upload.include_adjustment_test');

533: FETCH csr_is_included
534: INTO l_bal_type_id;
535: CLOSE csr_is_included;
536:
537: hr_utility.trace('Exiting pay_cn_bal_upload.include_adjustment_test');
538:
539: -- Adjustment does contribute to the new balance.
540:
541: IF l_bal_type_id IS NOT NULL THEN

Line 585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');

581: PROCEDURE validate_batch_lines (p_batch_id NUMBER)
582: IS
583:
584: BEGIN
585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');
586:
587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');
588:
589: END validate_batch_lines;

Line 587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');

583:
584: BEGIN
585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');
586:
587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');
588:
589: END validate_batch_lines;
590:
591: END pay_cn_bal_upload;