eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on HR_UTILITY

Line 356: --hr_utility.trace_on(null, 'TMPLT');

352: lt_freq_rule_table := p_freq_rule;
353:
354: -- end of initialization of Frequency rules
355:
356: --hr_utility.trace_on(null, 'TMPLT');
357:
358: l_proc := g_package || 'create_element';
359:
360: hr_utility.set_location('Entering '||l_proc, 10);

Line 360: hr_utility.set_location('Entering '||l_proc, 10);

356: --hr_utility.trace_on(null, 'TMPLT');
357:
358: l_proc := g_package || 'create_element';
359:
360: hr_utility.set_location('Entering '||l_proc, 10);
361:
362: OPEN get_busgrp_info(l_rec.business_group_name);
363: FETCH get_busgrp_info INTO ln_business_group_id
364: ,lv_legislation_code

Line 368: hr_utility.trace('Entered element_classification '||

364: ,lv_legislation_code
365: ,lv_currency_code;
366: CLOSE get_busgrp_info;
367:
368: hr_utility.trace('Entered element_classification '||
369: l_rec.element_classification);
370:
371: l_rec.element_classification :=
372: get_base_classification( lv_legislation_code

Line 376: hr_utility.trace('BASE element_classification '||

372: get_base_classification( lv_legislation_code
373: ,ln_business_group_id
374: ,l_rec.element_classification);
375:
376: hr_utility.trace('BASE element_classification '||
377: l_rec.element_classification);
378:
379: IF l_rec.legislation_code IS NULL THEN
380: l_rec.legislation_code := lv_legislation_code;

Line 383: hr_utility.set_location('Entering '||l_proc, 20);

379: IF l_rec.legislation_code IS NULL THEN
380: l_rec.legislation_code := lv_legislation_code;
381: END IF;
382:
383: hr_utility.set_location('Entering '||l_proc, 20);
384:
385: OPEN get_template_id ( l_rec.legislation_code, l_rec.calculation_rule );
386: FETCH get_template_id INTO l_source_template_id;
387: CLOSE get_template_id;

Line 389: hr_utility.set_location(l_proc, 40);

385: OPEN get_template_id ( l_rec.legislation_code, l_rec.calculation_rule );
386: FETCH get_template_id INTO l_source_template_id;
387: CLOSE get_template_id;
388:
389: hr_utility.set_location(l_proc, 40);
390:
391: IF l_rec.process_mode IS NOT NULL AND
392: l_rec.process_mode <> 'N' THEN
393:

Line 400: hr_utility.set_location(l_proc, 50);

396: OPEN get_rule_mode( l_rec.legislation_code );
397: FETCH get_rule_mode INTO lv_rule_mode;
398: CLOSE get_rule_mode;
399:
400: hr_utility.set_location(l_proc, 50);
401:
402: IF lv_rule_mode IS NOT NULL THEN
403:
404: SELECT COUNT(*)

Line 428: hr_utility.set_location(l_proc, 60);

424: l_rec.configuration_information3 := 'Y';
425:
426: END IF;
427:
428: hr_utility.set_location(l_proc, 60);
429:
430: END IF;
431:
432: END IF;

Line 458: hr_utility.set_location(l_proc, 70);

454: ln_processing_priority := p_rec.processing_priority;
455:
456: END IF;
457:
458: hr_utility.set_location(l_proc, 70);
459:
460: BEGIN
461:
462: EXECUTE IMMEDIATE 'BEGIN :a := PAY_'||l_rec.legislation_code||

Line 466: hr_utility.trace('l_rec.configuration_information1 ' ||

462: EXECUTE IMMEDIATE 'BEGIN :a := PAY_'||l_rec.legislation_code||
463: '_RULES.ELEMENT_TEMPLATE_PRE_PROCESS(:b); END;'
464: USING OUT l_rec, IN l_rec;
465:
466: hr_utility.trace('l_rec.configuration_information1 ' ||
467: l_rec.configuration_information1);
468: hr_utility.trace('l_rec.configuration_information4 ' ||
469: l_rec.configuration_information4);
470: hr_utility.trace('l_rec.configuration_information5 ' ||

Line 468: hr_utility.trace('l_rec.configuration_information4 ' ||

464: USING OUT l_rec, IN l_rec;
465:
466: hr_utility.trace('l_rec.configuration_information1 ' ||
467: l_rec.configuration_information1);
468: hr_utility.trace('l_rec.configuration_information4 ' ||
469: l_rec.configuration_information4);
470: hr_utility.trace('l_rec.configuration_information5 ' ||
471: l_rec.configuration_information5);
472: hr_utility.trace('l_rec.configuration_information6 ' ||

Line 470: hr_utility.trace('l_rec.configuration_information5 ' ||

466: hr_utility.trace('l_rec.configuration_information1 ' ||
467: l_rec.configuration_information1);
468: hr_utility.trace('l_rec.configuration_information4 ' ||
469: l_rec.configuration_information4);
470: hr_utility.trace('l_rec.configuration_information5 ' ||
471: l_rec.configuration_information5);
472: hr_utility.trace('l_rec.configuration_information6 ' ||
473: l_rec.configuration_information6);
474: hr_utility.trace('l_rec.configuration_information7 ' ||

Line 472: hr_utility.trace('l_rec.configuration_information6 ' ||

468: hr_utility.trace('l_rec.configuration_information4 ' ||
469: l_rec.configuration_information4);
470: hr_utility.trace('l_rec.configuration_information5 ' ||
471: l_rec.configuration_information5);
472: hr_utility.trace('l_rec.configuration_information6 ' ||
473: l_rec.configuration_information6);
474: hr_utility.trace('l_rec.configuration_information7 ' ||
475: l_rec.configuration_information7);
476:

Line 474: hr_utility.trace('l_rec.configuration_information7 ' ||

470: hr_utility.trace('l_rec.configuration_information5 ' ||
471: l_rec.configuration_information5);
472: hr_utility.trace('l_rec.configuration_information6 ' ||
473: l_rec.configuration_information6);
474: hr_utility.trace('l_rec.configuration_information7 ' ||
475: l_rec.configuration_information7);
476:
477: EXCEPTION
478: WHEN Cannot_Find_Prog_Unit THEN

Line 485: hr_utility.set_location(l_proc, 80);

481: raise;
482:
483: END;
484:
485: hr_utility.set_location(l_proc, 80);
486:
487: pay_element_template_api.create_user_structure
488: (p_validate => p_validate
489: ,p_effective_date => l_rec.effective_date

Line 560: hr_utility.set_location(l_proc, 50);

556: ,p_template_id => p_ele_template_id
557: ,p_object_version_number => l_object_version_number
558: );
559:
560: hr_utility.set_location(l_proc, 50);
561:
562: OPEN get_shd_ele_info( p_ele_template_id, l_rec.element_name );
563: FETCH get_shd_ele_info INTO ln_shd_ele_type_id
564: ,l_ele_obj_ver_number

Line 570: hr_utility.trace('Sub-class reccount='||to_char(lt_sub_class.count));

566: CLOSE get_shd_ele_info;
567:
568: IF ln_shd_ele_type_id IS NOT NULL THEN
569:
570: hr_utility.trace('Sub-class reccount='||to_char(lt_sub_class.count));
571:
572: IF lt_sub_class.count > 0 THEN
573:
574: FOR j IN lt_sub_class.FIRST..lt_sub_class.LAST LOOP

Line 580: hr_utility.trace('Sub-class rec-'||to_char(j)||

576: lr_sub_class := lt_sub_class(j);
577:
578: IF lr_sub_class.name IS NOT NULL THEN
579:
580: hr_utility.trace('Sub-class rec-'||to_char(j)||
581: '='||lr_sub_class.name);
582:
583: hr_utility.trace('Entered SUB element_classification '||
584: lr_sub_class.name);

Line 583: hr_utility.trace('Entered SUB element_classification '||

579:
580: hr_utility.trace('Sub-class rec-'||to_char(j)||
581: '='||lr_sub_class.name);
582:
583: hr_utility.trace('Entered SUB element_classification '||
584: lr_sub_class.name);
585:
586: lr_sub_class.name :=
587: get_base_classification( lv_legislation_code

Line 591: hr_utility.trace('BASE SUB element_classification '||

587: get_base_classification( lv_legislation_code
588: ,ln_business_group_id
589: ,lr_sub_class.name);
590:
591: hr_utility.trace('BASE SUB element_classification '||
592: lr_sub_class.name);
593:
594: lr_shadow_sub_class_rec.sub_classification_rule_id := null;
595: lr_shadow_sub_class_rec.element_type_id := ln_shd_ele_type_id;

Line 605: hr_utility.trace('Exit from Sub-class loop');

601: pay_ssr_ins.ins(l_rec.effective_date, lr_shadow_sub_class_rec);
602:
603: ELSIf lr_sub_class.name IS NULL THEN
604:
605: hr_utility.trace('Exit from Sub-class loop');
606: exit;
607:
608: END IF; -- lr_sub_class.name is not null
609:

Line 618: hr_utility.set_location(l_proc, 60);

614: END IF; --ln_shd_ele_type_id is not null
615:
616: /* End of Sub-classification rules creation */
617:
618: hr_utility.set_location(l_proc, 60);
619:
620: IF p_validate <> TRUE THEN
621:
622: lv_ip_installed := pay_ip_utility.get_ip_installation(ln_business_group_id);

Line 646: hr_utility.set_location(l_proc, 70);

642: ,p_output_currency_code => lv_currency_code
643: ,p_multiple_entries_allowed_fla => l_rec.multiple_entries_allowed
644: ,p_object_version_number => l_ele_obj_ver_number);
645:
646: hr_utility.set_location(l_proc, 70);
647:
648: BEGIN
649:
650: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||

Line 654: hr_utility.set_location(l_proc, 100);

650: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||
651: '_RULES.ELEMENT_TEMPLATE_UPD_USER_STRU(:c); END;'
652: USING p_ele_template_id;
653:
654: hr_utility.set_location(l_proc, 100);
655:
656: EXCEPTION
657: WHEN Cannot_Find_Prog_Unit THEN
658: null;

Line 673: hr_utility.set_location(l_proc, 80);

669: ,p_hr_only => FALSE
670: ,p_hr_to_payroll => FALSE
671: ,p_template_id => p_ele_template_id);
672:
673: hr_utility.set_location(l_proc, 80);
674:
675: pay_element_template_api.generate_part2
676: (p_validate => FALSE
677: ,p_effective_date => l_rec.effective_date

Line 680: hr_utility.set_location(l_proc, 90);

676: (p_validate => FALSE
677: ,p_effective_date => l_rec.effective_date
678: ,p_template_id => p_ele_template_id);
679:
680: hr_utility.set_location(l_proc, 90);
681:
682: lv_ip_installed := pay_ip_utility.get_ip_installation(ln_business_group_id);
683:
684: IF lv_ip_installed = 'N' THEN

Line 746: hr_utility.set_location(l_proc, 100);

742: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||
743: '_RULES.ELEMENT_TEMPLATE_POST_PROCESS(:c); END;'
744: USING p_ele_template_id;
745:
746: hr_utility.set_location(l_proc, 100);
747:
748: EXCEPTION
749: WHEN Cannot_Find_Prog_Unit THEN
750: null;

Line 758: hr_utility.trace('Start of Frequency Rule Creation ');

754: END;
755:
756: /* Added the Frequency Rule creation in core schema */
757:
758: hr_utility.trace('Start of Frequency Rule Creation ');
759:
760: OPEN get_core_shadow_object_id(p_ele_template_id,'ET');
761: FETCH get_core_shadow_object_id INTO ln_core_object_id,
762: ln_shadow_object_id;

Line 766: hr_utility.trace('ln_core_object_id :'||to_char(ln_core_object_id));

762: ln_shadow_object_id;
763: CLOSE get_core_shadow_object_id;
764:
765: lv_period_6 := 'N';
766: hr_utility.trace('ln_core_object_id :'||to_char(ln_core_object_id));
767:
768: IF ln_core_object_id IS NOT NULL AND
769: lt_freq_rule_table.count > 0 THEN
770:

Line 771: hr_utility.trace('Freq Rule Rec Count :'||

767:
768: IF ln_core_object_id IS NOT NULL AND
769: lt_freq_rule_table.count > 0 THEN
770:
771: hr_utility.trace('Freq Rule Rec Count :'||
772: to_char(lt_freq_rule_table.count));
773: hr_utility.trace('Start of Freq Rule Recs Loop');
774:
775: FOR k IN lt_freq_rule_table.FIRST..lt_freq_rule_table.LAST

Line 773: hr_utility.trace('Start of Freq Rule Recs Loop');

769: lt_freq_rule_table.count > 0 THEN
770:
771: hr_utility.trace('Freq Rule Rec Count :'||
772: to_char(lt_freq_rule_table.count));
773: hr_utility.trace('Start of Freq Rule Recs Loop');
774:
775: FOR k IN lt_freq_rule_table.FIRST..lt_freq_rule_table.LAST
776: LOOP
777:

Line 782: hr_utility.trace('Freq Rule Rec :'||to_char(k));

778: lr_freq_rule_rec := pay_freq_rule_obj(null,null,null,
779: null,null,null,null,null);
780: lr_freq_rule_rec := lt_freq_rule_table(k);
781:
782: hr_utility.trace('Freq Rule Rec :'||to_char(k));
783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);

Line 783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);

779: null,null,null,null,null);
780: lr_freq_rule_rec := lt_freq_rule_table(k);
781:
782: hr_utility.trace('Freq Rule Rec :'||to_char(k));
783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);

Line 784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);

780: lr_freq_rule_rec := lt_freq_rule_table(k);
781:
782: hr_utility.trace('Freq Rule Rec :'||to_char(k));
783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);

Line 785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);

781:
782: hr_utility.trace('Freq Rule Rec :'||to_char(k));
783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
789:

Line 786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);

782: hr_utility.trace('Freq Rule Rec :'||to_char(k));
783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
789:
790: IF lr_freq_rule_rec.payroll IS NOT NULL THEN

Line 787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);

783: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
789:
790: IF lr_freq_rule_rec.payroll IS NOT NULL THEN
791:

Line 788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);

784: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
785: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
786: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
787: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
788: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
789:
790: IF lr_freq_rule_rec.payroll IS NOT NULL THEN
791:
792: OPEN get_payroll_id(ln_business_group_id

Line 799: hr_utility.trace('Payroll Id :'||to_char(ln_payroll_id));

795:
796: FETCH get_payroll_id INTO ln_payroll_id;
797: CLOSE get_payroll_id;
798:
799: hr_utility.trace('Payroll Id :'||to_char(ln_payroll_id));
800:
801: pay_pyepfreq_pkg.hr_ele_pay_freq_rules
802: (p_context => 'ON-UPDATE',
803: p_eletype_id => ln_core_object_id,

Line 821: hr_utility.trace('End of Freq Rule Recs Loop');

817: END IF; -- lr_freq_rule_rec.payroll is not null
818:
819: END LOOP;
820:
821: hr_utility.trace('End of Freq Rule Recs Loop');
822:
823: /* Initialize Frequency Rule Plsql table that is used in
824: Summary Page of Element Template Wizard. */
825:

Line 834: hr_utility.set_location('Leaving '||l_proc, 1000);

830: /* End of Frequency Rule creation in core schema */
831:
832: END IF;
833:
834: hr_utility.set_location('Leaving '||l_proc, 1000);
835:
836: END create_element;
837:
838:

Line 861: hr_utility.set_location(l_proc, 10);

857: BEGIN
858:
859: l_proc := 'delete_element';
860:
861: hr_utility.set_location(l_proc, 10);
862:
863: OPEN cur_leg_code;
864: FETCH cur_leg_code
865: INTO l_legislation_code;

Line 868: hr_utility.set_location(l_proc, 20);

864: FETCH cur_leg_code
865: INTO l_legislation_code;
866: CLOSE cur_leg_code;
867:
868: hr_utility.set_location(l_proc, 20);
869:
870: BEGIN
871: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
872: '_RULES.DELETE_PRE_PROCESS(:c); END;'

Line 875: hr_utility.set_location(l_proc, 30);

871: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
872: '_RULES.DELETE_PRE_PROCESS(:c); END;'
873: USING p_template_id;
874:
875: hr_utility.set_location(l_proc, 30);
876:
877: EXCEPTION
878: WHEN Cannot_Find_Prog_Unit THEN
879: null;

Line 896: hr_utility.set_location(l_proc, 50);

892: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
893: '_RULES.DELETE_POST_PROCESS(:c); END;'
894: USING p_template_id;
895:
896: hr_utility.set_location(l_proc, 50);
897:
898: EXCEPTION
899: WHEN Cannot_Find_Prog_Unit THEN
900: null;