DBA Data[Home] [Help]

APPS.PAY_DK_RULES dependencies on HR_UTILITY

Line 368: -- hr_utility.trace_on(null,'dk_payslip');

364: ----------------
365:
366: BEGIN
367:
368: -- hr_utility.trace_on(null,'dk_payslip');
369: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
370: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
371: hr_utility.trace('p_action_information_category '|| p_action_information_category);
372: hr_utility.trace('p_document_type '|| p_document_type);

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

365:
366: BEGIN
367:
368: -- hr_utility.trace_on(null,'dk_payslip');
369: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
370: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
371: hr_utility.trace('p_action_information_category '|| p_action_information_category);
372: hr_utility.trace('p_document_type '|| p_document_type);
373:

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

366: BEGIN
367:
368: -- hr_utility.trace_on(null,'dk_payslip');
369: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
370: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
371: hr_utility.trace('p_action_information_category '|| p_action_information_category);
372: hr_utility.trace('p_document_type '|| p_document_type);
373:
374:

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

367:
368: -- hr_utility.trace_on(null,'dk_payslip');
369: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
370: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
371: hr_utility.trace('p_action_information_category '|| p_action_information_category);
372: hr_utility.trace('p_document_type '|| p_document_type);
373:
374:
375: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then

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

368: -- hr_utility.trace_on(null,'dk_payslip');
369: hr_utility.trace('Entering Pay_DK_RULES.add_custom_xml');
370: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
371: hr_utility.trace('p_action_information_category '|| p_action_information_category);
372: hr_utility.trace('p_document_type '|| p_document_type);
373:
374:
375: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
376:

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

373:
374:
375: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
376:
377: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
378:
379: -- ELEMENT DETAILS
380:
381: hr_utility.trace('ELEMENT DETAILS : start ');

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

377: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
378:
379: -- ELEMENT DETAILS
380:
381: hr_utility.trace('ELEMENT DETAILS : start ');
382:
383: -- Earning and Deduction Elements
384:
385: hr_utility.trace('Earnings and deductions : start ');

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

381: hr_utility.trace('ELEMENT DETAILS : start ');
382:
383: -- Earning and Deduction Elements
384:
385: hr_utility.trace('Earnings and deductions : start ');
386:
387: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
388: --
389:

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

386:
387: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
388: --
389:
390: hr_utility.trace('Inside FOR loop for csr_element_info. ');
391:
392: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
393: load_xml('CS', NULL, 'ELEMENT DETAILS', NULL) ;
394: --

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

427: --
428: END LOOP;
429: -- --
430:
431: hr_utility.trace('Earnings and deductions : end ');
432:
433: -- Additional Elements
434:
435: hr_utility.trace('Additional Elements : start ');

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

431: hr_utility.trace('Earnings and deductions : end ');
432:
433: -- Additional Elements
434:
435: hr_utility.trace('Additional Elements : start ');
436:
437: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
438: --
439:

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

436:
437: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'EMEA ELEMENT DEFINITION','EMEA ELEMENT INFO') LOOP
438: --
439:
440: hr_utility.trace('Inside FOR loop for csr_add_element_info. ');
441:
442: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
443: load_xml('CS', NULL, 'ELEMENT DETAILS', NULL) ;
444: --

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

468: END LOOP;
469: -- --
470:
471:
472: hr_utility.trace('Additional Elements : end ');
473:
474: hr_utility.trace('ELEMENT DETAILS : end ');
475:
476: -- PAYROLL PROCESSING INFORMATION

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

470:
471:
472: hr_utility.trace('Additional Elements : end ');
473:
474: hr_utility.trace('ELEMENT DETAILS : end ');
475:
476: -- PAYROLL PROCESSING INFORMATION
477:
478: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

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

474: hr_utility.trace('ELEMENT DETAILS : end ');
475:
476: -- PAYROLL PROCESSING INFORMATION
477:
478: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');
479:
480:
481: FOR payroll_info_rec IN csr_payroll_info(p_assignment_action_id , 'EMPLOYEE DETAILS' )
482: LOOP

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

507: --
508:
509: END LOOP;
510:
511: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
512:
513: hr_utility.trace('SUMMARY OF PAYMENTS : start ');
514:
515: -- SUMMARY OF PAYMENTS

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

509: END LOOP;
510:
511: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
512:
513: hr_utility.trace('SUMMARY OF PAYMENTS : start ');
514:
515: -- SUMMARY OF PAYMENTS
516: l_total_pay := l_total_earnings - l_total_deductions ;
517: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

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

527: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
528: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
529: --
530:
531: hr_utility.trace('SUMMARY OF PAYMENTS : end ');
532:
533: hr_utility.trace('BALANCE DETAILS : start ');
534:
535: -- BALANCE DETAILS

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

529: --
530:
531: hr_utility.trace('SUMMARY OF PAYMENTS : end ');
532:
533: hr_utility.trace('BALANCE DETAILS : start ');
534:
535: -- BALANCE DETAILS
536: --
537: l_cntr_sql := 1;

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

570: ,DBMS_SQL.V7);
571: ret := DBMS_SQL.EXECUTE(csr);
572: DBMS_SQL.CLOSE_CURSOR(csr);
573:
574: hr_utility.trace('BALANCE DETAILS : end ');
575: --
576: end if;
577: --hr_utility.trace_off();
578:

Line 577: --hr_utility.trace_off();

573:
574: hr_utility.trace('BALANCE DETAILS : end ');
575: --
576: end if;
577: --hr_utility.trace_off();
578:
579: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
580:
581: Exception

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

575: --
576: end if;
577: --hr_utility.trace_off();
578:
579: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
580:
581: Exception
582: when others then
583: hr_utility.trace('DK error message :'||sqlerrm);

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

579: hr_utility.trace('Leaving Pay_DK_RULES.add_custom_xml');
580:
581: Exception
582: when others then
583: hr_utility.trace('DK error message :'||sqlerrm);
584: Null ;
585:
586: END add_custom_xml;
587: