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 282: --hr_utility.trace_on(null, 'TMPLT');

278: lt_freq_rule_table := p_freq_rule;
279:
280: -- end of initialization of Frequency rules
281:
282: --hr_utility.trace_on(null, 'TMPLT');
283:
284: l_proc := g_package || 'create_element';
285:
286: hr_utility.set_location('Entering '||l_proc, 10);

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

282: --hr_utility.trace_on(null, 'TMPLT');
283:
284: l_proc := g_package || 'create_element';
285:
286: hr_utility.set_location('Entering '||l_proc, 10);
287:
288: OPEN get_busgrp_info(l_rec.business_group_name);
289: FETCH get_busgrp_info INTO ln_business_group_id
290: ,lv_legislation_code

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

290: ,lv_legislation_code
291: ,lv_currency_code;
292: CLOSE get_busgrp_info;
293:
294: hr_utility.trace('Entered element_classification '||
295: l_rec.element_classification);
296:
297: l_rec.element_classification :=
298: get_base_classification( lv_legislation_code

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

298: get_base_classification( lv_legislation_code
299: ,ln_business_group_id
300: ,l_rec.element_classification);
301:
302: hr_utility.trace('BASE element_classification '||
303: l_rec.element_classification);
304:
305: IF l_rec.legislation_code IS NULL THEN
306: l_rec.legislation_code := lv_legislation_code;

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

305: IF l_rec.legislation_code IS NULL THEN
306: l_rec.legislation_code := lv_legislation_code;
307: END IF;
308:
309: hr_utility.set_location('Entering '||l_proc, 20);
310:
311: OPEN get_template_id ( l_rec.legislation_code, l_rec.calculation_rule );
312: FETCH get_template_id INTO l_source_template_id;
313: CLOSE get_template_id;

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

311: OPEN get_template_id ( l_rec.legislation_code, l_rec.calculation_rule );
312: FETCH get_template_id INTO l_source_template_id;
313: CLOSE get_template_id;
314:
315: hr_utility.set_location(l_proc, 40);
316:
317: IF l_rec.process_mode IS NOT NULL AND
318: l_rec.process_mode <> 'N' THEN
319:

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

322: OPEN get_rule_mode( l_rec.legislation_code );
323: FETCH get_rule_mode INTO lv_rule_mode;
324: CLOSE get_rule_mode;
325:
326: hr_utility.set_location(l_proc, 50);
327:
328: IF lv_rule_mode IS NOT NULL THEN
329:
330: SELECT COUNT(*)

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

350: l_rec.configuration_information3 := 'Y';
351:
352: END IF;
353:
354: hr_utility.set_location(l_proc, 60);
355:
356: END IF;
357:
358: END IF;

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

380: ln_processing_priority := p_rec.processing_priority;
381:
382: END IF;
383:
384: hr_utility.set_location(l_proc, 70);
385:
386: BEGIN
387:
388: EXECUTE IMMEDIATE 'BEGIN :a := PAY_'||l_rec.legislation_code||

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

388: EXECUTE IMMEDIATE 'BEGIN :a := PAY_'||l_rec.legislation_code||
389: '_RULES.ELEMENT_TEMPLATE_PRE_PROCESS(:b); END;'
390: USING OUT l_rec, IN l_rec;
391:
392: hr_utility.trace('l_rec.configuration_information1 ' ||
393: l_rec.configuration_information1);
394: hr_utility.trace('l_rec.configuration_information4 ' ||
395: l_rec.configuration_information4);
396: hr_utility.trace('l_rec.configuration_information5 ' ||

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

390: USING OUT l_rec, IN l_rec;
391:
392: hr_utility.trace('l_rec.configuration_information1 ' ||
393: l_rec.configuration_information1);
394: hr_utility.trace('l_rec.configuration_information4 ' ||
395: l_rec.configuration_information4);
396: hr_utility.trace('l_rec.configuration_information5 ' ||
397: l_rec.configuration_information5);
398: hr_utility.trace('l_rec.configuration_information6 ' ||

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

392: hr_utility.trace('l_rec.configuration_information1 ' ||
393: l_rec.configuration_information1);
394: hr_utility.trace('l_rec.configuration_information4 ' ||
395: l_rec.configuration_information4);
396: hr_utility.trace('l_rec.configuration_information5 ' ||
397: l_rec.configuration_information5);
398: hr_utility.trace('l_rec.configuration_information6 ' ||
399: l_rec.configuration_information6);
400: hr_utility.trace('l_rec.configuration_information7 ' ||

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

394: hr_utility.trace('l_rec.configuration_information4 ' ||
395: l_rec.configuration_information4);
396: hr_utility.trace('l_rec.configuration_information5 ' ||
397: l_rec.configuration_information5);
398: hr_utility.trace('l_rec.configuration_information6 ' ||
399: l_rec.configuration_information6);
400: hr_utility.trace('l_rec.configuration_information7 ' ||
401: l_rec.configuration_information7);
402:

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

396: hr_utility.trace('l_rec.configuration_information5 ' ||
397: l_rec.configuration_information5);
398: hr_utility.trace('l_rec.configuration_information6 ' ||
399: l_rec.configuration_information6);
400: hr_utility.trace('l_rec.configuration_information7 ' ||
401: l_rec.configuration_information7);
402:
403: EXCEPTION
404: WHEN Cannot_Find_Prog_Unit THEN

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

407: raise;
408:
409: END;
410:
411: hr_utility.set_location(l_proc, 80);
412:
413: pay_element_template_api.create_user_structure
414: (p_validate => p_validate
415: ,p_effective_date => l_rec.effective_date

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

482: ,p_template_id => p_ele_template_id
483: ,p_object_version_number => l_object_version_number
484: );
485:
486: hr_utility.set_location(l_proc, 50);
487:
488: OPEN get_shd_ele_info( p_ele_template_id, l_rec.element_name );
489: FETCH get_shd_ele_info INTO ln_shd_ele_type_id
490: ,l_ele_obj_ver_number

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

492: CLOSE get_shd_ele_info;
493:
494: IF ln_shd_ele_type_id IS NOT NULL THEN
495:
496: hr_utility.trace('Sub-class reccount='||to_char(lt_sub_class.count));
497:
498: IF lt_sub_class.count > 0 THEN
499:
500: FOR j IN lt_sub_class.FIRST..lt_sub_class.LAST LOOP

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

502: lr_sub_class := lt_sub_class(j);
503:
504: IF lr_sub_class.name IS NOT NULL THEN
505:
506: hr_utility.trace('Sub-class rec-'||to_char(j)||
507: '='||lr_sub_class.name);
508:
509: hr_utility.trace('Entered SUB element_classification '||
510: lr_sub_class.name);

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

505:
506: hr_utility.trace('Sub-class rec-'||to_char(j)||
507: '='||lr_sub_class.name);
508:
509: hr_utility.trace('Entered SUB element_classification '||
510: lr_sub_class.name);
511:
512: lr_sub_class.name :=
513: get_base_classification( lv_legislation_code

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

513: get_base_classification( lv_legislation_code
514: ,ln_business_group_id
515: ,lr_sub_class.name);
516:
517: hr_utility.trace('BASE SUB element_classification '||
518: lr_sub_class.name);
519:
520: lr_shadow_sub_class_rec.sub_classification_rule_id := null;
521: lr_shadow_sub_class_rec.element_type_id := ln_shd_ele_type_id;

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

527: pay_ssr_ins.ins(l_rec.effective_date, lr_shadow_sub_class_rec);
528:
529: ELSIf lr_sub_class.name IS NULL THEN
530:
531: hr_utility.trace('Exit from Sub-class loop');
532: exit;
533:
534: END IF; -- lr_sub_class.name is not null
535:

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

540: END IF; --ln_shd_ele_type_id is not null
541:
542: /* End of Sub-classification rules creation */
543:
544: hr_utility.set_location(l_proc, 60);
545:
546: IF p_validate <> TRUE THEN
547:
548: pay_shadow_element_api.update_shadow_element

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

561: ,p_output_currency_code => lv_currency_code
562: ,p_multiple_entries_allowed_fla => l_rec.multiple_entries_allowed
563: ,p_object_version_number => l_ele_obj_ver_number);
564:
565: hr_utility.set_location(l_proc, 70);
566:
567: BEGIN
568:
569: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||

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

569: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||
570: '_RULES.ELEMENT_TEMPLATE_UPD_USER_STRU(:c); END;'
571: USING p_ele_template_id;
572:
573: hr_utility.set_location(l_proc, 100);
574:
575: EXCEPTION
576: WHEN Cannot_Find_Prog_Unit THEN
577: null;

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

588: ,p_hr_only => FALSE
589: ,p_hr_to_payroll => FALSE
590: ,p_template_id => p_ele_template_id);
591:
592: hr_utility.set_location(l_proc, 80);
593:
594: pay_element_template_api.generate_part2
595: (p_validate => FALSE
596: ,p_effective_date => l_rec.effective_date

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

595: (p_validate => FALSE
596: ,p_effective_date => l_rec.effective_date
597: ,p_template_id => p_ele_template_id);
598:
599: hr_utility.set_location(l_proc, 90);
600:
601: FOR formula in get_shd_formula_id( p_ele_template_id )
602: LOOP
603:

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

623: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_rec.legislation_code||
624: '_RULES.ELEMENT_TEMPLATE_POST_PROCESS(:c); END;'
625: USING p_ele_template_id;
626:
627: hr_utility.set_location(l_proc, 100);
628:
629: EXCEPTION
630: WHEN Cannot_Find_Prog_Unit THEN
631: null;

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

635: END;
636:
637: /* Added the Frequency Rule creation in core schema */
638:
639: hr_utility.trace('Start of Frequency Rule Creation ');
640:
641: OPEN get_core_shadow_object_id(p_ele_template_id,'ET');
642: FETCH get_core_shadow_object_id INTO ln_core_object_id,
643: ln_shadow_object_id;

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

643: ln_shadow_object_id;
644: CLOSE get_core_shadow_object_id;
645:
646: lv_period_6 := 'N';
647: hr_utility.trace('ln_core_object_id :'||to_char(ln_core_object_id));
648:
649: IF ln_core_object_id IS NOT NULL AND
650: lt_freq_rule_table.count > 0 THEN
651:

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

648:
649: IF ln_core_object_id IS NOT NULL AND
650: lt_freq_rule_table.count > 0 THEN
651:
652: hr_utility.trace('Freq Rule Rec Count :'||
653: to_char(lt_freq_rule_table.count));
654: hr_utility.trace('Start of Freq Rule Recs Loop');
655:
656: FOR k IN lt_freq_rule_table.FIRST..lt_freq_rule_table.LAST

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

650: lt_freq_rule_table.count > 0 THEN
651:
652: hr_utility.trace('Freq Rule Rec Count :'||
653: to_char(lt_freq_rule_table.count));
654: hr_utility.trace('Start of Freq Rule Recs Loop');
655:
656: FOR k IN lt_freq_rule_table.FIRST..lt_freq_rule_table.LAST
657: LOOP
658:

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

659: lr_freq_rule_rec := pay_freq_rule_obj(null,null,null,
660: null,null,null,null,null);
661: lr_freq_rule_rec := lt_freq_rule_table(k);
662:
663: hr_utility.trace('Freq Rule Rec :'||to_char(k));
664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);

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

660: null,null,null,null,null);
661: lr_freq_rule_rec := lt_freq_rule_table(k);
662:
663: hr_utility.trace('Freq Rule Rec :'||to_char(k));
664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);

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

661: lr_freq_rule_rec := lt_freq_rule_table(k);
662:
663: hr_utility.trace('Freq Rule Rec :'||to_char(k));
664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
669: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);

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

662:
663: hr_utility.trace('Freq Rule Rec :'||to_char(k));
664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
669: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
670:

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

663: hr_utility.trace('Freq Rule Rec :'||to_char(k));
664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
669: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
670:
671: IF lr_freq_rule_rec.payroll IS NOT NULL THEN

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

664: hr_utility.trace('Period 1 : '||lr_freq_rule_rec.period_1);
665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
669: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
670:
671: IF lr_freq_rule_rec.payroll IS NOT NULL THEN
672:

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

665: hr_utility.trace('Period 2 : '||lr_freq_rule_rec.period_2);
666: hr_utility.trace('Period 3 : '||lr_freq_rule_rec.period_3);
667: hr_utility.trace('Period 4 : '||lr_freq_rule_rec.period_4);
668: hr_utility.trace('Period 5 : '||lr_freq_rule_rec.period_5);
669: hr_utility.trace('RuleDateCode : '||lr_freq_rule_rec.date_option);
670:
671: IF lr_freq_rule_rec.payroll IS NOT NULL THEN
672:
673: OPEN get_payroll_id(ln_business_group_id

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

676:
677: FETCH get_payroll_id INTO ln_payroll_id;
678: CLOSE get_payroll_id;
679:
680: hr_utility.trace('Payroll Id :'||to_char(ln_payroll_id));
681:
682: pay_pyepfreq_pkg.hr_ele_pay_freq_rules
683: (p_context => 'ON-UPDATE',
684: p_eletype_id => ln_core_object_id,

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

698: END IF; -- lr_freq_rule_rec.payroll is not null
699:
700: END LOOP;
701:
702: hr_utility.trace('End of Freq Rule Recs Loop');
703:
704: /* Initialize Frequency Rule Plsql table that is used in
705: Summary Page of Element Template Wizard. */
706:

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

711: /* End of Frequency Rule creation in core schema */
712:
713: END IF;
714:
715: hr_utility.set_location('Leaving '||l_proc, 1000);
716:
717: END create_element;
718:
719:

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

738: BEGIN
739:
740: l_proc := 'delete_element';
741:
742: hr_utility.set_location(l_proc, 10);
743:
744: OPEN cur_leg_code;
745: FETCH cur_leg_code
746: INTO l_legislation_code;

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

745: FETCH cur_leg_code
746: INTO l_legislation_code;
747: CLOSE cur_leg_code;
748:
749: hr_utility.set_location(l_proc, 20);
750:
751: BEGIN
752: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
753: '_RULES.DELETE_PRE_PROCESS(:c); END;'

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

752: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
753: '_RULES.DELETE_PRE_PROCESS(:c); END;'
754: USING p_template_id;
755:
756: hr_utility.set_location(l_proc, 30);
757:
758: EXCEPTION
759: WHEN Cannot_Find_Prog_Unit THEN
760: null;

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

773: EXECUTE IMMEDIATE 'BEGIN PAY_'||l_legislation_code||
774: '_RULES.DELETE_POST_PROCESS(:c); END;'
775: USING p_template_id;
776:
777: hr_utility.set_location(l_proc, 50);
778:
779: EXCEPTION
780: WHEN Cannot_Find_Prog_Unit THEN
781: null;