DBA Data[Home] [Help]

APPS.PAY_DK_RULES dependencies on HR_UTILITY

Line 400: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');

396:
397: BEGIN
398:
399:
400: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
401: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
402: hr_utility.trace('p_action_information_category '|| p_action_information_category);
403: hr_utility.trace('p_document_type '|| p_document_type);
404:

Line 401: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);

397: BEGIN
398:
399:
400: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
401: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
402: hr_utility.trace('p_action_information_category '|| p_action_information_category);
403: hr_utility.trace('p_document_type '|| p_document_type);
404:
405:

Line 402: hr_utility.trace('p_action_information_category '|| p_action_information_category);

398:
399:
400: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
401: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
402: hr_utility.trace('p_action_information_category '|| p_action_information_category);
403: hr_utility.trace('p_document_type '|| p_document_type);
404:
405:
406: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then

Line 403: hr_utility.trace('p_document_type '|| p_document_type);

399:
400: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
401: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
402: hr_utility.trace('p_action_information_category '|| p_action_information_category);
403: hr_utility.trace('p_document_type '|| p_document_type);
404:
405:
406: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
407:

Line 408: hr_utility.trace('doc type is PAYSLIP and category is NULL ');

404:
405:
406: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
407:
408: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
409:
410: -- ELEMENT DETAILS
411:
412: hr_utility.trace('ELEMENT DETAILS : start ');

Line 412: hr_utility.trace('ELEMENT DETAILS : start ');

408: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
409:
410: -- ELEMENT DETAILS
411:
412: hr_utility.trace('ELEMENT DETAILS : start ');
413:
414: -- Earning and Deduction Elements
415:
416: hr_utility.trace('Earnings and deductions : start ');

Line 416: hr_utility.trace('Earnings and deductions : start ');

412: hr_utility.trace('ELEMENT DETAILS : start ');
413:
414: -- Earning and Deduction Elements
415:
416: hr_utility.trace('Earnings and deductions : start ');
417:
418: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
419: --
420:

Line 421: hr_utility.trace('Inside FOR loop for csr_element_info. ');

417:
418: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
419: --
420:
421: hr_utility.trace('Inside FOR loop for csr_element_info. ');
422:
423: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
424: load_xml('CS', NULL, 'ELEMENT DETAILS', NULL) ;
425: --

Line 474: hr_utility.trace('Earnings and deductions : end ');

470: --
471: END LOOP;
472: -- --
473:
474: hr_utility.trace('Earnings and deductions : end ');
475:
476: -- Additional Elements
477:
478: hr_utility.trace('Additional Elements : start ');

Line 478: hr_utility.trace('Additional Elements : start ');

474: hr_utility.trace('Earnings and deductions : end ');
475:
476: -- Additional Elements
477:
478: hr_utility.trace('Additional Elements : start ');
479:
480: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
481: --
482:

Line 483: hr_utility.trace('Inside FOR loop for csr_add_element_info. ');

479:
480: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
481: --
482:
483: hr_utility.trace('Inside FOR loop for csr_add_element_info. ');
484:
485: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
486: load_xml('CS', NULL, 'ELEMENT DETAILS', NULL) ;
487: --

Line 526: hr_utility.trace('Additional Elements : end ');

522: -- --
523: fnd_file.put_line(fnd_file.log,'This is the tested case2');
524:
525:
526: hr_utility.trace('Additional Elements : end ');
527:
528: hr_utility.trace('ELEMENT DETAILS : end ');
529:
530: -- PAYROLL PROCESSING INFORMATION

Line 528: hr_utility.trace('ELEMENT DETAILS : end ');

524:
525:
526: hr_utility.trace('Additional Elements : end ');
527:
528: hr_utility.trace('ELEMENT DETAILS : end ');
529:
530: -- PAYROLL PROCESSING INFORMATION
531:
532: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

Line 532: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

528: hr_utility.trace('ELEMENT DETAILS : end ');
529:
530: -- PAYROLL PROCESSING INFORMATION
531:
532: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');
533:
534:
535: FOR payroll_info_rec IN csr_payroll_info(p_assignment_action_id , 'EMPLOYEE DETAILS' )
536: LOOP

Line 565: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');

561: --
562:
563: END LOOP;
564:
565: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
566:
567: hr_utility.trace('SUMMARY OF PAYMENTS : start ');
568:
569: -- SUMMARY OF PAYMENTS

Line 567: hr_utility.trace('SUMMARY OF PAYMENTS : start ');

563: END LOOP;
564:
565: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
566:
567: hr_utility.trace('SUMMARY OF PAYMENTS : start ');
568:
569: -- SUMMARY OF PAYMENTS
570: l_total_pay := l_total_earnings - l_total_deductions ;
571: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 585: hr_utility.trace('SUMMARY OF PAYMENTS : end ');

581: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
582: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
583: --
584:
585: hr_utility.trace('SUMMARY OF PAYMENTS : end ');
586:
587: hr_utility.trace('BALANCE DETAILS : start ');
588:
589: fnd_file.put_line(fnd_file.log,'This is the tested case1');

Line 587: hr_utility.trace('BALANCE DETAILS : start ');

583: --
584:
585: hr_utility.trace('SUMMARY OF PAYMENTS : end ');
586:
587: hr_utility.trace('BALANCE DETAILS : start ');
588:
589: fnd_file.put_line(fnd_file.log,'This is the tested case1');
590:
591: -- BALANCE DETAILS

Line 630: hr_utility.trace('BALANCE DETAILS : end ');

626: ,DBMS_SQL.V7);
627: ret := DBMS_SQL.EXECUTE(csr);
628: DBMS_SQL.CLOSE_CURSOR(csr);
629:
630: hr_utility.trace('BALANCE DETAILS : end ');
631: --
632: end if;
633: --hr_utility.trace_off();
634:

Line 633: --hr_utility.trace_off();

629:
630: hr_utility.trace('BALANCE DETAILS : end ');
631: --
632: end if;
633: --hr_utility.trace_off();
634:
635: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
636:
637: Exception

Line 635: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');

631: --
632: end if;
633: --hr_utility.trace_off();
634:
635: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
636:
637: Exception
638: when others then
639: hr_utility.trace('DK error message :'||sqlerrm);

Line 639: hr_utility.trace('DK error message :'||sqlerrm);

635: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
636:
637: Exception
638: when others then
639: hr_utility.trace('DK error message :'||sqlerrm);
640: Null ;
641:
642: END add_custom_xml;
643:

Line 694: hr_utility.set_location('Entering procedure archinit' , 1);

690:
691: begin
692:
693:
694: hr_utility.set_location('Entering procedure archinit' , 1);
695:
696: SELECT legislative_parameters,payroll_id
697: INTO leg_param,l_ppa_payroll_id
698: FROM pay_payroll_actions

Line 712: hr_utility.set_location('l_payroll_id'|| l_payroll_id , 2);

708: end if;
709: end if;
710:
711: -- Update the Payroll Action with the Payroll ID
712: hr_utility.set_location('l_payroll_id'|| l_payroll_id , 2);
713: IF l_ppa_payroll_id IS NULL and l_payroll_id is not NULL THEN
714:
715: UPDATE pay_payroll_actions
716: SET payroll_id = l_payroll_id

Line 718: hr_utility.set_location('After Update', 2);

714:
715: UPDATE pay_payroll_actions
716: SET payroll_id = l_payroll_id
717: WHERE payroll_action_id = p_payroll_action_id;
718: hr_utility.set_location('After Update', 2);
719:
720: END IF;
721:
722:

Line 724: hr_utility.set_location('leaving procedure archinit' , 5);

720: END IF;
721:
722:
723:
724: hr_utility.set_location('leaving procedure archinit' , 5);
725:
726: end archinit;
727: /* 10156538 end */
728: