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.HR_GENERATE_PRETAX dependencies on HR_UTILITY

Line 91: 16-jun-1999 achauhan 110.10 Replaced dbms_output with hr_utility

87: 10 Mar 1999 ahanda 40.19 Changed GRE_ITD to ASG_ITD as GRE_ITD
88: is already there in suffixes(26) and
89: ASG_ITD is missing in the
90: pretax_deduction_template. Bug 820068
91: 16-jun-1999 achauhan 110.10 Replaced dbms_output with hr_utility
92: 09-jul-1999 vmehta 110.11 Added check for legislation_code
93: while retrieving classification for
94: employer match BUG 912994
95: 27-oct-1999 dscully Added check for legislation_code while

Line 409: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',10);

405: v_business_group_id number;
406:
407: BEGIN
408:
409: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',10);
410:
411: suffixes(1) := '_ASG_RUN';
412: suffixes(2) := '_ASG_PTD';
413: suffixes(3) := '_ASG_MONTH';

Line 469: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',20);

465: /* WWBug 133133, 350540 finish */
466:
467: for i in 1..num_suffixes loop
468:
469: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',20);
470:
471: select dimension_name, balance_dimension_id
472: into dim_name, dim_id
473: from pay_balance_dimensions

Line 478: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',30);

474: where database_item_suffix = suffixes(i)
475: and legislation_code = g_template_leg_code
476: and business_group_id IS NULL;
477:
478: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',30);
479:
480: /* added line to include business_group_id in the where clause of the select
481: statement below. So that it checkes the existence of data for a the given
482: business_group_id Bug No: 502307.

Line 497: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',40);

493: if (already_exists = 0) then
494:
495: IF p_no_payments = TRUE and suffixes(i) = '_PAYMENTS' THEN
496:
497: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',40);
498:
499: NULL;
500:
501: ELSE

Line 503: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',50);

499: NULL;
500:
501: ELSE
502:
503: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',50);
504:
505: pay_db_pay_setup.create_defined_balance(
506: p_balance_name => p_bal_name,
507: p_balance_dimension => dim_name,

Line 517: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',60);

513: end if;
514:
515: end loop;
516:
517: hr_utility.set_location('hr_generate_pretax.do_defined_balances ',60);
518:
519: END do_defined_balances;
520:
521: --

Line 552: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',10);

548: already_exists number;
549:
550: BEGIN
551:
552: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',10);
553:
554: IF p_ele_processing_type = 'N' THEN
555:
556: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',20);

Line 556: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',20);

552: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',10);
553:
554: IF p_ele_processing_type = 'N' THEN
555:
556: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',20);
557:
558: v_mult_entries_allowed := 'Y';
559:
560: END IF;

Line 562: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',50);

558: v_mult_entries_allowed := 'Y';
559:
560: END IF;
561:
562: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',50);
563:
564: already_exists := hr_template_existence.ele_exists(
565: p_ele_name => p_ele_name,
566: p_bg_id => p_bg_id,

Line 571: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',55);

567: p_eff_date => p_ele_eff_start_date);
568:
569: if already_exists = 0 then
570:
571: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',55);
572:
573: ret := pay_db_pay_setup.create_element(
574: p_element_name => p_ele_name,
575: p_description => p_ele_description,

Line 591: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',80);

587: p_effective_end_date => p_ele_eff_end_date,
588: p_legislation_code => NULL,
589: p_third_party_pay_only => v_third_ppm);
590:
591: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',80);
592:
593: else
594:
595: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',90);

Line 595: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',90);

591: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',80);
592:
593: else
594:
595: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',90);
596:
597: if p_ele_name = dedn_ele_names(1) then
598:
599: -- Base element already exists, this MUST be called via upgrade mechanism.

Line 611: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',100);

607: ret := already_exists;
608:
609: end if;
610:
611: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',100);
612:
613: RETURN ret;
614:
615: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 617: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',999);

613: RETURN ret;
614:
615: EXCEPTION WHEN NO_DATA_FOUND THEN
616:
617: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',999);
618:
619: RETURN ret;
620:
621: END ins_dedn_ele_type;

Line 655: hr_utility.set_location('hr_generate_pretax.ins_base_formula',10);

651: already_exists number;
652:
653: BEGIN
654:
655: hr_utility.set_location('hr_generate_pretax.ins_base_formula',10);
656:
657: SELECT FF.formula_text,
658: FF.formula_type_id
659: INTO v_skeleton_formula_text,

Line 670: hr_utility.set_location('hr_generate_pretax.ins_base_formula',15);

666: AND g_eff_start_date <= FF.effective_end_date;
667:
668: -- Replace element name placeholders with current element name:
669:
670: hr_utility.set_location('hr_generate_pretax.ins_base_formula',15);
671:
672: l_placehold_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
673: v_new_ele_formula_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
674: v_new_ele_formula_text := REPLACE( v_skeleton_formula_text,

Line 685: hr_utility.set_location('hr_generate_pretax.ins_base_formula',20);

681: -- Call function to check existence of formula to get id.
682: -- Get original formula id, name, and text for this element currently,
683: -- ie. before putting in new ff text.
684:
685: hr_utility.set_location('hr_generate_pretax.ins_base_formula',20);
686:
687: already_exists := hr_template_existence.ele_ff_exists(
688: p_ele_name => p_spr_ele_name,
689: p_bg_id => p_ff_bg_id,

Line 701: hr_utility.set_location('hr_generate_pretax.ins_base_formula',30);

697: -- there is no formula for this element currently.
698: --
699: -- Get new id for formula
700:
701: hr_utility.set_location('hr_generate_pretax.ins_base_formula',30);
702:
703: SELECT ff_formulas_s.nextval
704: INTO v_new_ele_formula_id
705: FROM sys.dual;

Line 707: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);

703: SELECT ff_formulas_s.nextval
704: INTO v_new_ele_formula_id
705: FROM sys.dual;
706:
707: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);
708:
709: -- hr_utility.trace('Inserting ff '||v_new_ele_formula_name||' for ele '||p_ff_ele_name);
710:
711: INSERT INTO ff_formulas_f ( FORMULA_ID,

Line 709: -- hr_utility.trace('Inserting ff '||v_new_ele_formula_name||' for ele '||p_ff_ele_name);

705: FROM sys.dual;
706:
707: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);
708:
709: -- hr_utility.trace('Inserting ff '||v_new_ele_formula_name||' for ele '||p_ff_ele_name);
710:
711: INSERT INTO ff_formulas_f ( FORMULA_ID,
712: EFFECTIVE_START_DATE,
713: EFFECTIVE_END_DATE,

Line 749: hr_utility.set_location('hr_generate_pretax.ins_base_formula',50);

745: -- Element already has formula attached via stat proc rule...
746: -- original formula name and text have been populated as outputs
747: -- from check for existence.
748:
749: hr_utility.set_location('hr_generate_pretax.ins_base_formula',50);
750:
751: v_new_ele_formula_id := already_exists;
752:
753: -- Update existing formula with new ff name and text.

Line 755: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');

751: v_new_ele_formula_id := already_exists;
752:
753: -- Update existing formula with new ff name and text.
754:
755: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
756: -- hr_utility.trace(v_new_ele_formula_name);
757:
758: hr_utility.set_location('hr_generate_pretax.ins_base_formula',70);
759:

Line 756: -- hr_utility.trace(v_new_ele_formula_name);

752:
753: -- Update existing formula with new ff name and text.
754:
755: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
756: -- hr_utility.trace(v_new_ele_formula_name);
757:
758: hr_utility.set_location('hr_generate_pretax.ins_base_formula',70);
759:
760: /*

Line 758: hr_utility.set_location('hr_generate_pretax.ins_base_formula',70);

754:
755: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
756: -- hr_utility.trace(v_new_ele_formula_name);
757:
758: hr_utility.set_location('hr_generate_pretax.ins_base_formula',70);
759:
760: /*
761: UPDATE ff_formulas_f
762: SET formula_name = v_new_ele_formula_name,

Line 779: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);

775:
776: --
777: -- Insert the original formula into current business group to preserve customer mods.
778: --
779: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
780:
781: select count(0)
782: into l_count_already
783: from ff_formulas_f

Line 787: hr_utility.set_location('hr_generate_pretax.ins_base_formula',35);

783: from ff_formulas_f
784: where upper(formula_name) like upper('%'||l_placehold_ele_name||'%');
785:
786:
787: hr_utility.set_location('hr_generate_pretax.ins_base_formula',35);
788:
789: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);
790:
791: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;

Line 789: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);

785:
786:
787: hr_utility.set_location('hr_generate_pretax.ins_base_formula',35);
788:
789: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);
790:
791: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
792: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
793:

Line 794: -- hr_utility.trace('Renamed ff name is '||v_orig_ele_formula_name);

790:
791: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
792: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
793:
794: -- hr_utility.trace('Renamed ff name is '||v_orig_ele_formula_name);
795:
796: hr_utility.set_location('hr_generate_pretax.ins_base_formula',30);
797:
798: SELECT ff_formulas_s.nextval

Line 796: hr_utility.set_location('hr_generate_pretax.ins_base_formula',30);

792: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
793:
794: -- hr_utility.trace('Renamed ff name is '||v_orig_ele_formula_name);
795:
796: hr_utility.set_location('hr_generate_pretax.ins_base_formula',30);
797:
798: SELECT ff_formulas_s.nextval
799: INTO v_orig_ele_formula_id
800: FROM sys.dual;

Line 802: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);

798: SELECT ff_formulas_s.nextval
799: INTO v_orig_ele_formula_id
800: FROM sys.dual;
801:
802: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);
803:
804: INSERT INTO ff_formulas_f ( FORMULA_ID,
805: EFFECTIVE_START_DATE,
806: EFFECTIVE_END_DATE,

Line 885: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',10);

881: already_exists number;
882:
883: BEGIN
884:
885: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',10);
886:
887: SELECT FF.formula_text,
888: FF.formula_type_id
889: INTO v_skeleton_formula_text,

Line 900: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',15);

896: AND g_eff_start_date <= FF.effective_end_date;
897:
898: -- Replace element name placeholders with current element name:
899:
900: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',15);
901:
902: l_placehold_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
903: v_new_ele_formula_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
904: v_new_ele_formula_text := REPLACE( v_skeleton_formula_text,

Line 928: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',17);

924: IF p_amt_rule = 'PT' THEN
925:
926: IF p_row_type NOT IN ('Salary Range', 'Age Range') THEN
927:
928: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',17);
929:
930: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
931: '',
932: REPLACE(LTRIM(RTRIM(p_row_type)),' ','_'));

Line 934: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',19);

930: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
931: '',
932: REPLACE(LTRIM(RTRIM(p_row_type)),' ','_'));
933:
934: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',19);
935:
936: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
937: '',
938: 'default for ' || REPLACE(LTRIM(RTRIM(p_row_type)),' ','_') || ' (text) is ''NOT ENTERED''');

Line 940: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',21);

936: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
937: '',
938: 'default for ' || REPLACE(LTRIM(RTRIM(p_row_type)),' ','_') || ' (text) is ''NOT ENTERED''');
939:
940: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',21);
941:
942: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
943: '',
944: ',' || REPLACE(LTRIM(RTRIM(p_row_type)),' ','_') || ' (text)');

Line 948: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',20);

944: ',' || REPLACE(LTRIM(RTRIM(p_row_type)),' ','_') || ' (text)');
945:
946: ELSE
947:
948: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',20);
949:
950: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
951: '',
952: 'To_Char(PER_AGE)');

Line 954: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',22);

950: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
951: '',
952: 'To_Char(PER_AGE)');
953:
954: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',22);
955:
956: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
957: '',
958: ' ');

Line 960: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',24);

956: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
957: '',
958: ' ');
959:
960: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',24);
961:
962: v_new_ele_formula_text := REPLACE(v_new_ele_formula_text,
963: '',
964: ' ');

Line 971: hr_utility.set_location('hr_user_init_dedn.ins_formula',23);

967:
968: --
969: -- "Zero" benefits
970: --
971: hr_utility.set_location('hr_user_init_dedn.ins_formula',23);
972: v_new_ele_formula_text := REPLACE( v_new_ele_formula_text,
973: l_placehold_ele_name || '_BEN_EE_CONTR_VALUE',
974: '0');
975:

Line 993: hr_utility.set_location('hr_user_init_dedn.ins_formula',25);

989:
990: --
991: -- Using benefits, _BEN_EE_CONTR_VALUE is already taken care of.
992: --
993: hr_utility.set_location('hr_user_init_dedn.ins_formula',25);
994: v_new_ele_formula_text := REPLACE( v_new_ele_formula_text,
995: '',
996: 'default for ' || l_placehold_ele_name || '_BEN_EE_CONTR_VALUE is 0');
997:

Line 1020: hr_utility.set_location('hr_user_init_dedn.ins_formula',27);

1016:
1017: --
1018: -- Clear out everything!
1019: -- Clear out
1020: hr_utility.set_location('hr_user_init_dedn.ins_formula',27);
1021: v_new_ele_formula_text := REPLACE( v_new_ele_formula_text,
1022: '',
1023: '''NOT ENTERED''');
1024:

Line 1061: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',20);

1057: -- Call function to check existence of formula to get id.
1058: -- Get original formula id, name, and text for this element currently,
1059: -- ie. before putting in new ff text.
1060:
1061: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',20);
1062:
1063: already_exists := hr_template_existence.ele_ff_exists(
1064: p_ele_name => p_spr_ele_name,
1065: p_bg_id => p_ff_bg_id,

Line 1077: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',30);

1073: -- there is no formula for this element currently.
1074: --
1075: -- Get new id for formula
1076:
1077: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',30);
1078:
1079: SELECT ff_formulas_s.nextval
1080: INTO v_new_ele_formula_id
1081: FROM sys.dual;

Line 1083: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',40);

1079: SELECT ff_formulas_s.nextval
1080: INTO v_new_ele_formula_id
1081: FROM sys.dual;
1082:
1083: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',40);
1084:
1085: INSERT INTO ff_formulas_f ( FORMULA_ID,
1086: EFFECTIVE_START_DATE,
1087: EFFECTIVE_END_DATE,

Line 1123: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',50);

1119: -- Element already has formula attached via stat proc rule...
1120: -- original formula name and text have been populated as outputs
1121: -- from check for existence.
1122:
1123: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',50);
1124:
1125: v_new_ele_formula_id := already_exists;
1126:
1127: -- Update existing formula with new ff name and text.

Line 1129: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',70);

1125: v_new_ele_formula_id := already_exists;
1126:
1127: -- Update existing formula with new ff name and text.
1128:
1129: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',70);
1130:
1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
1132: -- hr_utility.trace(v_new_ele_formula_name);
1133:

Line 1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');

1127: -- Update existing formula with new ff name and text.
1128:
1129: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',70);
1130:
1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
1132: -- hr_utility.trace(v_new_ele_formula_name);
1133:
1134: /* Hitting constraint error FF_FORMULAS_F_UK2 with...
1135: UPDATE ff_formulas_f

Line 1132: -- hr_utility.trace(v_new_ele_formula_name);

1128:
1129: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',70);
1130:
1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
1132: -- hr_utility.trace(v_new_ele_formula_name);
1133:
1134: /* Hitting constraint error FF_FORMULAS_F_UK2 with...
1135: UPDATE ff_formulas_f
1136: SET formula_name = v_new_ele_formula_name,

Line 1154: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);

1150:
1151: --
1152: -- Insert the original formula into current business group to preserve customer mods.
1153: --
1154: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
1155:
1156: select count(0)
1157: into l_count_already
1158: from ff_formulas_f

Line 1161: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);

1157: into l_count_already
1158: from ff_formulas_f
1159: where upper(formula_name) like upper('%'||l_placehold_ele_name||'%');
1160:
1161: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);
1162:
1163: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',80);
1164:
1165: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;

Line 1163: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',80);

1159: where upper(formula_name) like upper('%'||l_placehold_ele_name||'%');
1160:
1161: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);
1162:
1163: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',80);
1164:
1165: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
1166: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
1167:

Line 1168: -- hr_utility.trace('Original formula now in ff called '||v_orig_ele_formula_name);

1164:
1165: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
1166: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
1167:
1168: -- hr_utility.trace('Original formula now in ff called '||v_orig_ele_formula_name);
1169:
1170: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',90);
1171:
1172: SELECT ff_formulas_s.nextval

Line 1170: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',90);

1166: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
1167:
1168: -- hr_utility.trace('Original formula now in ff called '||v_orig_ele_formula_name);
1169:
1170: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',90);
1171:
1172: SELECT ff_formulas_s.nextval
1173: INTO v_orig_ele_formula_id
1174: FROM sys.dual;

Line 1176: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',100);

1172: SELECT ff_formulas_s.nextval
1173: INTO v_orig_ele_formula_id
1174: FROM sys.dual;
1175:
1176: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',100);
1177:
1178: INSERT INTO ff_formulas_f ( FORMULA_ID,
1179: EFFECTIVE_START_DATE,
1180: EFFECTIVE_END_DATE,

Line 1320: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);

1316: IF UPPER(p_amount_rule) = 'PE' THEN
1317:
1318: -- Set DDF segments
1319:
1320: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1321:
1322: -- For CALCULATOR ele, set mix flag and ben class if approp...
1323: UPDATE pay_element_types_f
1324: SET element_information_category = g_ele_info_cat,

Line 1343: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);

1339: benefit_classification_id = NULL
1340: WHERE element_type_id = dedn_ele_ids(2)
1341: AND business_group_id + 0 = p_bg_id;
1342:
1343: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1344:
1345: UPDATE pay_element_types_f
1346: SET element_information_category = g_ele_info_cat,
1347: element_information1 = p_ele_cat,

Line 1353: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);

1349: element_information3 = p_proc_runtype
1350: WHERE element_type_id = dedn_ele_ids(4)
1351: AND business_group_id + 0 = p_bg_id;
1352:
1353: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1354:
1355: UPDATE pay_element_types_f
1356: SET element_information_category = g_ele_info_cat,
1357: element_information1 = p_ele_cat,

Line 1363: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',15);

1359: element_information3 = p_proc_runtype
1360: WHERE element_type_id = dedn_ele_ids(3)
1361: AND business_group_id + 0 = p_bg_id;
1362:
1363: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',15);
1364:
1365: -- Check for payroll table amount rule...
1366: ELSIF UPPER(p_amount_rule) = 'PT' THEN
1367:

Line 1370: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',53);

1366: ELSIF UPPER(p_amount_rule) = 'PT' THEN
1367:
1368: -- Find table id
1369:
1370: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',53);
1371:
1372: SELECT user_table_id
1373: INTO v_paytab_id
1374: FROM pay_user_tables

Line 1380: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',55);

1376: AND NVL(business_group_id, p_bg_id) = p_bg_id;
1377:
1378: -- Find row code
1379:
1380: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',55);
1381:
1382: SELECT lookup_code
1383: INTO v_row_code
1384: FROM hr_lookups

Line 1388: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);

1384: FROM hr_lookups
1385: WHERE UPPER(meaning) = UPPER(p_paytab_row_type)
1386: AND lookup_type = 'US_TABLE_ROW_TYPES';
1387:
1388: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1389:
1390: -- For CALCULATOR, set mix flag and ben class...
1391: UPDATE pay_element_types_f
1392: SET element_information_category = g_ele_info_cat,

Line 1415: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);

1411: benefit_classification_id = NULL
1412: WHERE element_type_id = dedn_ele_ids(2)
1413: AND business_group_id + 0 = p_bg_id;
1414:
1415: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1416:
1417:
1418: UPDATE pay_element_types_f
1419: SET element_information_category = g_ele_info_cat,

Line 1428: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);

1424: element_information7 = v_row_code
1425: WHERE element_type_id = dedn_ele_ids(4)
1426: AND business_group_id + 0 = p_bg_id;
1427:
1428: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1429:
1430:
1431: UPDATE pay_element_types_f
1432: SET element_information_category = g_ele_info_cat,

Line 1441: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',59);

1437: element_information7 = v_row_code
1438: WHERE element_type_id = dedn_ele_ids(3)
1439: AND business_group_id + 0 = p_bg_id;
1440:
1441: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',59);
1442:
1443:
1444: -- Check for Benefits Table amount rule...
1445: ELSIF UPPER(p_amount_rule) = 'BT' THEN

Line 1469: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);

1465: WHERE element_type_id = dedn_ele_ids(2)
1466: AND business_group_id + 0 = p_bg_id;
1467:
1468:
1469: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);
1470:
1471:
1472: UPDATE pay_element_types_f
1473: SET element_information_category = g_ele_info_cat,

Line 1481: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);

1477: WHERE element_type_id = dedn_ele_ids(4)
1478: AND business_group_id + 0 = p_bg_id;
1479:
1480:
1481: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);
1482:
1483: UPDATE pay_element_types_f
1484: SET element_information_category = g_ele_info_cat,
1485: element_information1 = p_ele_cat,

Line 1492: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',85);

1488: WHERE element_type_id = dedn_ele_ids(3)
1489: AND business_group_id + 0 = p_bg_id;
1490:
1491:
1492: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',85);
1493:
1494: ELSE
1495: --
1496: -- Default to Flat Amount processing of deduction.

Line 1500: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);

1496: -- Default to Flat Amount processing of deduction.
1497: -- Set DDF Segment values:
1498: --
1499:
1500: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1501:
1502: -- Set mix flag and ben class on CALCULATOR element...
1503: UPDATE pay_element_types_f
1504: SET element_information_category = g_ele_info_cat,

Line 1524: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);

1520: WHERE element_type_id = dedn_ele_ids(2)
1521: AND business_group_id + 0 = p_bg_id;
1522:
1523:
1524: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1525:
1526:
1527: UPDATE pay_element_types_f
1528: SET element_information_category = g_ele_info_cat,

Line 1535: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);

1531: element_information3 = p_proc_runtype
1532: WHERE element_type_id = dedn_ele_ids(4)
1533: AND business_group_id + 0 = p_bg_id;
1534:
1535: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1536:
1537:
1538: UPDATE pay_element_types_f
1539: SET element_information_category = g_ele_info_cat,

Line 1546: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',15);

1542: element_information3 = p_proc_runtype
1543: WHERE element_type_id = dedn_ele_ids(3)
1544: AND business_group_id + 0 = p_bg_id;
1545:
1546: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',15);
1547:
1548: END IF; -- Amount rule checks for formula insertion...
1549:
1550:

Line 1581: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',17);

1577:
1578: l_ff_suffix := '_PERCENTAGE_PTX';
1579: l_ff_desc := 'Percentage calculation for deductions.';
1580:
1581: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',17);
1582:
1583: ELSIF UPPER(p_amount_rule) = 'PT' THEN
1584:
1585: l_iv_defaults_ff_text := ' default for '||l_placeholder_ele_name||'_TABLE_COLUMN_ENTRY_VALUE IS ''NOT ENTERED'' ';

Line 1589: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',75);

1585: l_iv_defaults_ff_text := ' default for '||l_placeholder_ele_name||'_TABLE_COLUMN_ENTRY_VALUE IS ''NOT ENTERED'' ';
1586:
1587: IF p_paytab_row_type NOT IN ('Salary Range', 'Age Range') THEN
1588:
1589: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',75);
1590: l_iv_defaults_ff_text := l_iv_defaults_ff_text||' default for ' || REPLACE(LTRIM(RTRIM(p_paytab_row_type)),' ','_') || ' (text) is ''NOT ENTERED'' ';
1591:
1592: END IF;
1593:

Line 1653: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);

1649:
1650: l_ff_suffix := '_FLAT_PTX';
1651: l_ff_desc := 'Flat Amount calculation for deductions.';
1652:
1653: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);
1654:
1655: END IF;
1656:
1657:

Line 1679: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',87);

1675: p_row_type => NULL,
1676: p_iv_dflts_text => l_iv_defaults_ff_text,
1677: p_calc_dedn_text => l_calc_dedn_ff_text );
1678:
1679: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',87);
1680:
1681: --
1682: -- Now setup withholding formula on WITHHOLDING element...
1683: --

Line 1693: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);

1689:
1690: --
1691: -- check for existence of status proc rule...function returns id if it does...
1692: --
1693: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);
1694:
1695: -- hr_utility.trace('spr exists checking...');
1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);
1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);

Line 1695: -- hr_utility.trace('spr exists checking...');

1691: -- check for existence of status proc rule...function returns id if it does...
1692: --
1693: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);
1694:
1695: -- hr_utility.trace('spr exists checking...');
1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);
1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1698: -- Calculator status proc rule...
1699: already_exists := hr_template_existence.spr_exists (

Line 1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);

1692: --
1693: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);
1694:
1695: -- hr_utility.trace('spr exists checking...');
1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);
1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1698: -- Calculator status proc rule...
1699: already_exists := hr_template_existence.spr_exists (
1700: p_ele_id => dedn_ele_ids(1),

Line 1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);

1693: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',119);
1694:
1695: -- hr_utility.trace('spr exists checking...');
1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);
1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1698: -- Calculator status proc rule...
1699: already_exists := hr_template_existence.spr_exists (
1700: p_ele_id => dedn_ele_ids(1),
1701: p_ff_id => v_spr_formula_id,

Line 1707: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',121);

1703: p_val_date => p_eff_start_date);
1704:
1705: if already_exists = 0 then
1706:
1707: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',121);
1708: v_stat_proc_rule_id :=
1709: pay_formula_results.ins_stat_proc_rule (
1710: p_business_group_id => p_bg_id,
1711: p_legislation_code => NULL,

Line 1726: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',123);

1722: else
1723:
1724: -- Statproc rule already exists for calculator element.
1725:
1726: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',123);
1727:
1728: v_stat_proc_rule_id := already_exists;
1729: dedn_statproc_rule_id(1) := v_stat_proc_rule_id;
1730:

Line 1747: -- hr_utility.trace('spr exists checking...');

1743: END IF;
1744:
1745: end if;
1746:
1747: -- hr_utility.trace('spr exists checking...');
1748: -- hr_utility.trace(dedn_ele_ids(2)||' '||v_wh_formula_id);
1749: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1750: -- Check for base status proc rule existence...
1751: already_exists := hr_template_existence.spr_exists (

Line 1748: -- hr_utility.trace(dedn_ele_ids(2)||' '||v_wh_formula_id);

1744:
1745: end if;
1746:
1747: -- hr_utility.trace('spr exists checking...');
1748: -- hr_utility.trace(dedn_ele_ids(2)||' '||v_wh_formula_id);
1749: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1750: -- Check for base status proc rule existence...
1751: already_exists := hr_template_existence.spr_exists (
1752: p_ele_id => dedn_ele_ids(2),

Line 1749: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);

1745: end if;
1746:
1747: -- hr_utility.trace('spr exists checking...');
1748: -- hr_utility.trace(dedn_ele_ids(2)||' '||v_wh_formula_id);
1749: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1750: -- Check for base status proc rule existence...
1751: already_exists := hr_template_existence.spr_exists (
1752: p_ele_id => dedn_ele_ids(2),
1753: p_ff_id => v_spr_formula_id,

Line 1759: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',125);

1755: p_val_date => p_eff_start_date);
1756:
1757: if already_exists = 0 then
1758:
1759: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',125);
1760: v_stat_proc_rule_id :=
1761: pay_formula_results.ins_stat_proc_rule (
1762: p_business_group_id => p_bg_id,
1763: p_legislation_code => NULL,

Line 1778: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',127);

1774: else
1775:
1776: -- Statproc rule already exists for calculator element.
1777:
1778: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',127);
1779:
1780: v_stat_proc_rule_id := already_exists;
1781: dedn_statproc_rule_id(2) := v_stat_proc_rule_id;
1782:

Line 1810: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);

1806: -- formula result rules...
1807:
1808: IF UPPER(p_amount_rule) = 'PE' THEN
1809:
1810: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);
1811:
1812: dedn_base_iv_names(1) := 'Percentage';
1813: dedn_base_iv_uom(1) := 'Number';
1814: dedn_base_iv_mand(1) := 'N';

Line 1835: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);

1831: -- the SCL and formula picks it up from there. This will amount
1832: -- to an input value required when the user enters a value OTHER
1833: -- then "Salary Range" or "Age Range" in the Row Type field.
1834:
1835: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);
1836:
1837: dedn_base_iv_names(1) := 'Table Column';
1838: dedn_base_iv_uom(1) := 'Character';
1839: dedn_base_iv_mand(1) := 'N';

Line 1849: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);

1845: dedn_base_iv_names(3) := NULL;
1846:
1847: l_num_base_ivs := 3;
1848:
1849: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);
1850:
1851: -- Place logic determining to create or not create additional input value here:
1852: -- 1) If p_paytab_row_type = 'Age Range' or 'Salary Range' then DO NOT create
1853: -- addl inpval;

Line 1862: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',75);

1858: --
1859:
1860: IF p_paytab_row_type NOT IN ('Salary Range', 'Age Range') THEN
1861:
1862: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',75);
1863:
1864: dedn_base_iv_names(2) := p_paytab_row_type;
1865: dedn_base_iv_uom(2) := 'Character';
1866: dedn_base_iv_mand(2) := 'N';

Line 1879: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);

1875: END IF; -- rowtype = dbi name check.
1876:
1877: ELSIF UPPER(p_amount_rule) = 'BT' THEN
1878:
1879: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',65);
1880:
1881: dedn_base_iv_names(1) := 'Coverage';
1882: dedn_base_iv_uom(1) := 'Character';
1883: dedn_base_iv_mand(1) := 'N';

Line 2127: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);

2123: FOR h in 1..l_num_base_ivs LOOP
2124:
2125: IF dedn_base_iv_names(h) IS NOT NULL THEN
2126:
2127: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);
2128:
2129: already_exists := hr_template_existence.iv_name_exists(
2130: p_ele_id => dedn_ele_ids(1),
2131: p_bg_id => p_bg_id,

Line 2137: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);

2133: p_eff_date => g_eff_start_date);
2134:
2135: if already_exists = 0 then
2136:
2137: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);
2138:
2139: select max(display_sequence)
2140: into dedn_base_seq
2141: from pay_input_values_f

Line 2175: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);

2171: p_effective_end_date => g_eff_end_date);
2172:
2173: dedn_base_iv_ids(h) := v_inpval_id;
2174:
2175: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);
2176:
2177: hr_input_values.chk_input_value(
2178: p_element_type_id => dedn_ele_ids(1),
2179: p_legislation_code => g_template_leg_code,

Line 2200: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);

2196: p_formula_id => NULL,
2197: p_generate_db_items_flag => dedn_base_iv_dbi(h),
2198: p_warning_or_error => NULL);
2199:
2200: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);
2201:
2202: hr_input_values.ins_3p_input_values(
2203: p_val_start_date => g_eff_start_date,
2204: p_val_end_date => g_eff_end_date,

Line 2243: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);

2239: p_effective_end_date => g_eff_end_date);
2240:
2241: dedn_base_iv_ids(h) := v_inpval_id;
2242:
2243: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);
2244:
2245: pay_template_ivs.chk_input_value(
2246: p_element_type_id => dedn_ele_ids(1),
2247: p_legislation_code => g_template_leg_code,

Line 2268: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);

2264: p_formula_id => NULL,
2265: p_generate_db_items_flag => dedn_base_iv_dbi(h),
2266: p_warning_or_error => NULL);
2267:
2268: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);
2269:
2270: pay_template_ivs.ins_3p_input_values(
2271: p_val_start_date => g_eff_start_date,
2272: p_val_end_date => g_eff_end_date,

Line 2301: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',340);

2297: END IF;
2298:
2299: else
2300:
2301: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',340);
2302:
2303: v_inpval_id := already_exists;
2304: dedn_base_iv_ids(h) := v_inpval_id;
2305:

Line 2322: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);

2318: FOR k in 1..l_num_wh_ivs LOOP
2319:
2320: IF dedn_wh_iv_names(k) IS NOT NULL THEN
2321:
2322: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);
2323:
2324: already_exists := hr_template_existence.iv_name_exists(
2325: p_ele_id => dedn_ele_ids(2),
2326: p_bg_id => p_bg_id,

Line 2332: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);

2328: p_eff_date => g_eff_start_date);
2329:
2330: if already_exists = 0 then
2331:
2332: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);
2333:
2334: select max(display_sequence)
2335: into dedn_wh_seq
2336: from pay_input_values_f

Line 2370: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);

2366: p_effective_end_date => g_eff_end_date);
2367:
2368: dedn_wh_iv_ids(k) := v_inpval_id;
2369:
2370: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);
2371:
2372: hr_input_values.chk_input_value(
2373: p_element_type_id => dedn_ele_ids(2),
2374: p_legislation_code => g_template_leg_code,

Line 2395: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);

2391: p_formula_id => NULL,
2392: p_generate_db_items_flag => dedn_wh_iv_dbi(k),
2393: p_warning_or_error => NULL);
2394:
2395: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);
2396:
2397: hr_input_values.ins_3p_input_values(
2398: p_val_start_date => g_eff_start_date,
2399: p_val_end_date => g_eff_end_date,

Line 2438: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);

2434: p_effective_end_date => g_eff_end_date);
2435:
2436: dedn_wh_iv_ids(k) := v_inpval_id;
2437:
2438: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',320);
2439:
2440: pay_template_ivs.chk_input_value(
2441: p_element_type_id => dedn_ele_ids(2),
2442: p_legislation_code => g_template_leg_code,

Line 2463: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);

2459: p_formula_id => NULL,
2460: p_generate_db_items_flag => dedn_wh_iv_dbi(k),
2461: p_warning_or_error => NULL);
2462:
2463: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',330);
2464:
2465: pay_template_ivs.ins_3p_input_values(
2466: p_val_start_date => g_eff_start_date,
2467: p_val_end_date => g_eff_end_date,

Line 2496: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',340);

2492: END IF;
2493:
2494: else
2495:
2496: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',340);
2497:
2498: v_inpval_id := already_exists;
2499: dedn_wh_iv_ids(k) := v_inpval_id;
2500:

Line 2517: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',110);

2513: --
2514: -- Create inpvals for "Special Inputs"
2515: --
2516:
2517: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',110);
2518:
2519: dedn_si_iv_names(1) := 'Replace Amt';
2520: dedn_si_iv_uom(1) := 'Money';
2521: dedn_si_iv_mand(1) := 'N';

Line 2547: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',120);

2543: -- Now create all special inputs element input values.
2544: --
2545: FOR siv in 1..l_num_si_ivs LOOP
2546:
2547: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',120);
2548:
2549: already_exists := hr_template_existence.iv_name_exists(
2550: p_ele_id => dedn_ele_ids(3),
2551: p_bg_id => p_bg_id,

Line 2557: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',130);

2553: p_eff_date => g_eff_start_date);
2554:
2555: if already_exists = 0 then
2556:
2557: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',130);
2558:
2559: select max(display_sequence)
2560: into dedn_iv_seq
2561: from pay_input_values_f

Line 2568: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',140);

2564: and effective_end_date;
2565:
2566: dedn_iv_seq := dedn_iv_seq + 1;
2567:
2568: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',140);
2569:
2570: /* 40.4 : Call new API to add input value over life of element if
2571: upgrade mode = Yes
2572: */

Line 2597: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',150);

2593: p_effective_end_date => g_eff_end_date);
2594:
2595: dedn_si_iv_ids(siv) := v_inpval_id;
2596:
2597: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',150);
2598:
2599: hr_input_values.chk_input_value(
2600: p_element_type_id => dedn_ele_ids(3),
2601: p_legislation_code => g_template_leg_code,

Line 2622: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',160);

2618: p_formula_id => NULL,
2619: p_generate_db_items_flag => dedn_si_iv_dbi(siv),
2620: p_warning_or_error => NULL);
2621:
2622: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',160);
2623:
2624: hr_input_values.ins_3p_input_values(
2625: p_val_start_date => g_eff_start_date,
2626: p_val_end_date => g_eff_end_date,

Line 2665: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',150);

2661: p_effective_end_date => g_eff_end_date);
2662:
2663: dedn_si_iv_ids(siv) := v_inpval_id;
2664:
2665: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',150);
2666:
2667: pay_template_ivs.chk_input_value(
2668: p_element_type_id => dedn_ele_ids(3),
2669: p_legislation_code => g_template_leg_code,

Line 2690: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',160);

2686: p_formula_id => NULL,
2687: p_generate_db_items_flag => dedn_si_iv_dbi(siv),
2688: p_warning_or_error => NULL);
2689:
2690: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',160);
2691:
2692: pay_template_ivs.ins_3p_input_values(
2693: p_val_start_date => g_eff_start_date,
2694: p_val_end_date => g_eff_end_date,

Line 2723: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',170);

2719: END IF;
2720:
2721: else
2722:
2723: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',170);
2724:
2725: v_inpval_id := already_exists;
2726:
2727: dedn_si_iv_ids(siv) := v_inpval_id;

Line 2737: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',180);

2733: --
2734: -- Create inpvals for "Special Features"
2735: --
2736:
2737: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',180);
2738:
2739: dedn_sf_iv_names(3) := 'Replacement Amt';
2740: dedn_sf_iv_uom(3) := 'Money';
2741: dedn_sf_iv_mand(3) := 'N';

Line 2783: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',190);

2779: FOR sfv in 1..l_num_sf_ivs LOOP
2780:
2781: IF dedn_sf_iv_names(sfv) IS NOT NULL THEN
2782:
2783: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',190);
2784:
2785: already_exists := hr_template_existence.iv_name_exists(
2786: p_ele_id => dedn_ele_ids(4),
2787: p_bg_id => p_bg_id,

Line 2793: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',200);

2789: p_eff_date => g_eff_start_date);
2790:
2791: if already_exists = 0 then
2792:
2793: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',200);
2794:
2795: select max(display_sequence)
2796: into dedn_iv_seq
2797: from pay_input_values_f

Line 2804: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',210);

2800: and effective_end_date;
2801:
2802: dedn_iv_seq := dedn_iv_seq + 1;
2803:
2804: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',210);
2805:
2806: /* 40.4 : Call new API to add input value over life of element if
2807: upgrade mode = Yes
2808: */

Line 2833: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',220);

2829: p_effective_end_date => g_eff_end_date);
2830:
2831: dedn_sf_iv_ids(sfv) := v_inpval_id;
2832:
2833: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',220);
2834:
2835: hr_input_values.chk_input_value(
2836: p_element_type_id => dedn_ele_ids(4),
2837: p_legislation_code => g_template_leg_code,

Line 2858: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',230);

2854: p_formula_id => NULL,
2855: p_generate_db_items_flag => dedn_sf_iv_dbi(sfv),
2856: p_warning_or_error => NULL);
2857:
2858: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',230);
2859:
2860: hr_input_values.ins_3p_input_values(
2861: p_val_start_date => g_eff_start_date,
2862: p_val_end_date => g_eff_end_date,

Line 2901: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',220);

2897: p_effective_end_date => g_eff_end_date);
2898:
2899: dedn_sf_iv_ids(sfv) := v_inpval_id;
2900:
2901: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',220);
2902:
2903: pay_template_ivs.chk_input_value(
2904: p_element_type_id => dedn_ele_ids(4),
2905: p_legislation_code => g_template_leg_code,

Line 2926: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',230);

2922: p_formula_id => NULL,
2923: p_generate_db_items_flag => dedn_sf_iv_dbi(sfv),
2924: p_warning_or_error => NULL);
2925:
2926: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',230);
2927:
2928: pay_template_ivs.ins_3p_input_values(
2929: p_val_start_date => g_eff_start_date,
2930: p_val_end_date => g_eff_end_date,

Line 2959: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',240);

2955: END IF;
2956:
2957: else
2958:
2959: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',240);
2960:
2961: v_inpval_id := already_exists;
2962: dedn_sf_iv_ids(sfv) := v_inpval_id;
2963:

Line 3001: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',400);

2997: FOR m in 1..l_num_er_ivs LOOP
2998:
2999: IF dedn_er_iv_names(m)IS NOT NULL THEN
3000:
3001: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',400);
3002:
3003: already_exists := hr_template_existence.iv_name_exists(
3004: p_ele_id => dedn_ele_ids(5),
3005: p_bg_id => p_bg_id,

Line 3011: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',410);

3007: p_eff_date => g_eff_start_date);
3008:
3009: if already_exists = 0 then
3010:
3011: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',410);
3012:
3013: select max(display_sequence)
3014: into dedn_er_seq
3015: from pay_input_values_f

Line 3049: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',420);

3045: p_effective_end_date => g_eff_end_date);
3046:
3047: dedn_er_iv_ids(m) := v_inpval_id;
3048:
3049: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',420);
3050:
3051: hr_input_values.chk_input_value(
3052: p_element_type_id => dedn_ele_ids(5),
3053: p_legislation_code => g_template_leg_code,

Line 3074: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',430);

3070: p_formula_id => NULL,
3071: p_generate_db_items_flag => dedn_er_iv_dbi(m),
3072: p_warning_or_error => NULL);
3073:
3074: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',430);
3075:
3076: hr_input_values.ins_3p_input_values(
3077: p_val_start_date => g_eff_start_date,
3078: p_val_end_date => g_eff_end_date,

Line 3117: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',420);

3113: p_effective_end_date => g_eff_end_date);
3114:
3115: dedn_er_iv_ids(m) := v_inpval_id;
3116:
3117: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',420);
3118:
3119: pay_template_ivs.chk_input_value(
3120: p_element_type_id => dedn_ele_ids(5),
3121: p_legislation_code => g_template_leg_code,

Line 3142: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',430);

3138: p_formula_id => NULL,
3139: p_generate_db_items_flag => dedn_er_iv_dbi(m),
3140: p_warning_or_error => NULL);
3141:
3142: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',430);
3143:
3144: pay_template_ivs.ins_3p_input_values(
3145: p_val_start_date => g_eff_start_date,
3146: p_val_end_date => g_eff_end_date,

Line 3175: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',440);

3171: END IF;
3172:
3173: else
3174:
3175: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',440);
3176:
3177: v_inpval_id := already_exists;
3178: dedn_er_iv_ids(m) := v_inpval_id;
3179:

Line 3230: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',47);

3226: dedn_calc_frr_severity(3) := 'W';
3227:
3228: l_num_calc_resrules := 3;
3229:
3230: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',47);
3231:
3232: IF UPPER(p_amount_rule) = 'BT' THEN
3233:
3234: --

Line 3240: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',115);

3236: -- this benefit, we must find the input_value_id for the pay_value of the
3237: -- employer charge element.
3238: --
3239:
3240: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',115);
3241:
3242: dedn_calc_frr_name(4) := 'BENE_ER_CONTR';
3243: dedn_calc_frr_type(4) := 'I';
3244: dedn_calc_frr_ele_id(4) := dedn_ele_ids(5);

Line 3260: hr_utility.set_location('hr_generate_pretax.ins_uie_inp_values',90);

3256: END IF;
3257:
3258: IF p_ele_proc_type = 'R' THEN
3259:
3260: hr_utility.set_location('hr_generate_pretax.ins_uie_inp_values',90);
3261:
3262: dedn_calc_frr_name(5) := 'CLEAR_REPL_AMT';
3263: dedn_calc_frr_type(5) := 'I';
3264: dedn_calc_frr_ele_id(5) := dedn_ele_ids(4);

Line 3424: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',450);

3420:
3421: -- create formula result rule for:
3422: -- (*) to_arrears --> Indirect to .ARREARS_CONTR
3423:
3424: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',450);
3425:
3426: dedn_wh_frr_name(9) := 'TO_ARREARS';
3427: dedn_wh_frr_type(9) := 'I';
3428: dedn_wh_frr_ele_id(9) := dedn_ele_ids(4);

Line 3466: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);

3462: FOR n in 1..l_num_wh_resrules LOOP
3463:
3464: IF dedn_wh_frr_name(n) IS NOT NULL THEN
3465:
3466: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);
3467:
3468: already_exists := hr_template_existence.result_rule_exists(
3469: p_spr_id => dedn_statproc_rule_id(2),
3470: p_frr_name => dedn_wh_frr_name(n),

Line 3478: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',280);

3474: p_eff_date => g_eff_start_date);
3475:
3476: if already_exists = 0 then
3477:
3478: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',280);
3479:
3480: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
3481: p_business_group_id => p_bg_id,
3482: p_legislation_code => NULL,

Line 3495: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',290);

3491: p_element_type_id => dedn_wh_frr_ele_id(n));
3492:
3493: else
3494:
3495: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',290);
3496: v_fres_rule_id := already_exists;
3497:
3498: end if;
3499:

Line 3515: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);

3511: FOR n in 1..l_num_calc_resrules LOOP
3512:
3513: IF dedn_calc_frr_name(n) IS NOT NULL THEN
3514:
3515: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);
3516:
3517: already_exists := hr_template_existence.result_rule_exists(
3518: p_spr_id => dedn_statproc_rule_id(1),
3519: p_frr_name => dedn_calc_frr_name(n),

Line 3527: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',280);

3523: p_eff_date => g_eff_start_date);
3524:
3525: if already_exists = 0 then
3526:
3527: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',280);
3528:
3529: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
3530: p_business_group_id => p_bg_id,
3531: p_legislation_code => NULL,

Line 3544: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',290);

3540: p_element_type_id => dedn_calc_frr_ele_id(n));
3541:
3542: else
3543:
3544: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',290);
3545: v_fres_rule_id := already_exists;
3546:
3547: end if;
3548:

Line 3705: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',10);

3701:
3702: --
3703: -- Set session date
3704:
3705: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',10);
3706:
3707: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3708: g_eff_start_date := nvl(p_ele_eff_start_date, sysdate);
3709: g_eff_end_date := nvl(p_ele_eff_end_date, c_end_of_time);

Line 3713: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',20);

3709: g_eff_end_date := nvl(p_ele_eff_end_date, c_end_of_time);
3710:
3711: -- Set "globals": v_bg_name
3712:
3713: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',20);
3714: select name
3715: into v_bg_name
3716: from per_business_groups
3717: where business_group_id = p_bg_id;

Line 3793: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',50);

3789: p_eff_date => g_eff_start_date);
3790:
3791: if already_exists = 0 then
3792:
3793: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',50);
3794:
3795: -- ARE WE ABSOLUTELY COMFORTABLE WITH REPORTING NAME = BAL NAME?!
3796: -- DESC PAY_BALANCE_TYPES TO SEE COL LENGTHS.
3797:

Line 3807: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',60);

3803: p_balance_name => dedn_assoc_bal_names(i),
3804: p_reporting_name => dedn_assoc_bal_rep_names(i),
3805: p_assignment_remuneration_flag => 'N');
3806:
3807: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',60);
3808:
3809: -- Also check balance name is unique to Startup data balances.
3810: pay_balance_types_pkg.chk_balance_type(
3811: p_row_id => NULL,

Line 3818: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',70);

3814: p_balance_name => dedn_assoc_bal_names(i),
3815: p_reporting_name => dedn_assoc_bal_rep_names(i),
3816: p_assignment_remuneration_flag => 'N');
3817:
3818: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',70);
3819:
3820: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3821: p_balance_name => dedn_assoc_bal_names(i),
3822: p_uom => dedn_assoc_bal_uom(i),

Line 3828: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',80);

3824: p_business_group_name => v_bg_name,
3825: p_legislation_code => NULL,
3826: p_legislation_subgroup => NULL);
3827:
3828: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',80);
3829:
3830: dedn_assoc_bal_ids(i) := v_bal_type_id;
3831:
3832: else

Line 3834: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',90);

3830: dedn_assoc_bal_ids(i) := v_bal_type_id;
3831:
3832: else
3833:
3834: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',90);
3835:
3836: dedn_assoc_bal_ids(i) := already_exists;
3837:
3838: end if;

Line 3843: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',100);

3839:
3840: --
3841: -- Defined Balances (ie. balance type associated with a dimension)
3842: --
3843: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',100);
3844:
3845: do_defined_balances( p_bal_name => dedn_assoc_bal_names(i),
3846: p_bg_name => v_bg_name);
3847:

Line 3848: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',110);

3844:
3845: do_defined_balances( p_bal_name => dedn_assoc_bal_names(i),
3846: p_bg_name => v_bg_name);
3847:
3848: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',110);
3849:
3850: if dedn_assoc_bal_rep_names(i) like '%Eligible%' then
3851:
3852: open get_reg_earn_feeds(p_bg_id);

Line 3890: hr_utility.set_location('hr_generate_pretax.upgrade_template',10);

3886: -- Need to determine and get skip rule formula id and pass it
3887: -- create_element.
3888: --
3889:
3890: hr_utility.set_location('hr_generate_pretax.upgrade_template',10);
3891:
3892: IF UPPER(p_ele_start_rule) = 'CHAINED' THEN
3893:
3894: hr_utility.set_location('hr_generate_pretax.upgrade_template',15);

Line 3894: hr_utility.set_location('hr_generate_pretax.upgrade_template',15);

3890: hr_utility.set_location('hr_generate_pretax.upgrade_template',10);
3891:
3892: IF UPPER(p_ele_start_rule) = 'CHAINED' THEN
3893:
3894: hr_utility.set_location('hr_generate_pretax.upgrade_template',15);
3895:
3896: SELECT FF.formula_id
3897: INTO v_skip_formula_id
3898: FROM ff_formulas_f FF

Line 3907: hr_utility.set_location('hr_generate_pretax.upgrade_template',20);

3903: AND p_ele_eff_start_date <= FF.effective_end_date;
3904:
3905: ELSIF UPPER(p_ele_start_rule) = 'ET' THEN
3906:
3907: hr_utility.set_location('hr_generate_pretax.upgrade_template',20);
3908: SELECT FF.formula_id
3909: INTO v_skip_formula_id
3910: FROM ff_formulas_f FF
3911: WHERE FF.formula_name = 'THRESHOLD_SKIP_FORMULA'

Line 3919: hr_utility.set_location('hr_generate_pretax.upgrade_template',25);

3915: AND p_ele_eff_start_date <= FF.effective_end_date;
3916:
3917: ELSE -- Just check skip rule and separate check flag.
3918:
3919: hr_utility.set_location('hr_generate_pretax.upgrade_template',25);
3920:
3921: SELECT FF.formula_id
3922: INTO v_skip_formula_id
3923: FROM ff_formulas_f FF

Line 3951: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);

3947: -- Need to find PRIMARY_CLASSIFICATION_ID of element type.
3948: -- For future calls to various API.
3949: --
3950:
3951: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);
3952:
3953: begin
3954:
3955: select distinct(classification_id)

Line 3964: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);

3960: and legislation_code = 'US';
3961:
3962: exception when no_data_found then
3963:
3964: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);
3965: hr_utility.set_location('*** Error: Element Classification NOT FOUND. ***',999);
3966:
3967:
3968: end;

Line 3965: hr_utility.set_location('* Error: Element Classification NOT FOUND. *',999);

3961:
3962: exception when no_data_found then
3963:
3964: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);
3965: hr_utility.set_location('*** Error: Element Classification NOT FOUND. ***',999);
3966:
3967:
3968: end;
3969:

Line 3970: hr_utility.set_location('pyusuiet',130);

3966:
3967:
3968: end;
3969:
3970: hr_utility.set_location('pyusuiet',130);
3971:
3972: begin
3973:
3974: SELECT default_low_priority,

Line 3985: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);

3981: AND legislation_code = 'US';
3982:
3983: exception when no_data_found then
3984:
3985: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);
3986: hr_utility.set_location('*** Error: Classification priorities NOT FOUND. ***',999);
3987:
3988: end;
3989:

Line 3986: hr_utility.set_location('* Error: Classification priorities NOT FOUND. *',999);

3982:
3983: exception when no_data_found then
3984:
3985: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',999);
3986: hr_utility.set_location('*** Error: Classification priorities NOT FOUND. ***',999);
3987:
3988: end;
3989:
3990: -- Find default priority for Involuntary Deductions classification

Line 4084: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',55);

4080: l_num_eles := 4;
4081:
4082: IF p_ele_amount_rule = 'BT' or p_ele_er_match = 'Y' THEN
4083:
4084: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',55);
4085:
4086: select default_priority
4087: into v_emp_liab_dflt_prio
4088: from pay_element_classifications

Line 4120: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',51);

4116: for x in 1..l_num_eles LOOP
4117:
4118: IF dedn_ele_names(x) IS NOT NULL THEN
4119:
4120: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',51);
4121:
4122: v_ele_type_id := ins_dedn_ele_type ( dedn_ele_names(x),
4123: dedn_ele_repnames(x),
4124: dedn_ele_desc(x),

Line 4144: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);

4140: -- Make pay value non enterable.
4141:
4142: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4143:
4144: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);
4145:
4146: -- hr_utility.trace('Updating '||v_pay_value_name||' for '||dedn_ele_names(x));
4147:
4148: UPDATE pay_input_values_f

Line 4146: -- hr_utility.trace('Updating '||v_pay_value_name||' for '||dedn_ele_names(x));

4142: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4143:
4144: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);
4145:
4146: -- hr_utility.trace('Updating '||v_pay_value_name||' for '||dedn_ele_names(x));
4147:
4148: UPDATE pay_input_values_f
4149: SET mandatory_flag = 'X'
4150: WHERE element_type_id = v_ele_type_id

Line 4159: hr_utility.set_location('hr_upgrade_earnings. upgrade_template',157);

4155: FROM pay_input_values_f
4156: WHERE element_type_id = v_ele_type_id
4157: AND name = v_pay_value_name;
4158:
4159: hr_utility.set_location('hr_upgrade_earnings. upgrade_template',157);
4160:
4161: dedn_payval_id(x) := v_payval_id;
4162:
4163: ELSE

Line 4171: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',57);

4167: END IF;
4168:
4169: END LOOP;
4170:
4171: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',57);
4172:
4173: IF p_ele_amount_rule = 'BT' or p_ele_er_match = 'Y' THEN
4174: --
4175: -- Create "Primary" balance for ER Liab and "associate" appropriately.

Line 4179: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',58);

4175: -- Create "Primary" balance for ER Liab and "associate" appropriately.
4176: -- Is there any way to table these optional objects that go with optional elements?
4177: --
4178:
4179: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',58);
4180:
4181: v_balance_name := dedn_ele_names(5);
4182: v_bal_rpt_name := dedn_ele_repnames(5);
4183:

Line 4230: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',90);

4226: p_eff_date => g_eff_start_date );
4227:
4228: if ALREADY_EXISTS = 0 then
4229:
4230: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',90);
4231:
4232: hr_balances.ins_balance_feed(
4233: p_option => 'INS_MANUAL_FEED',
4234: p_input_value_id => dedn_payval_id(5),

Line 4254: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',68);

4250: --
4251: -------------------------- Insert Formula Processing records -------------
4252: --
4253:
4254: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',68);
4255:
4256: ins_dedn_formula_processing ( dedn_ele_names(1),
4257: v_primary_class_id,
4258: p_ele_classification,

Line 4279: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',69);

4275: g_eff_start_date,
4276: g_eff_end_date,
4277: v_bg_name);
4278:
4279: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',69);
4280:
4281: --
4282: ------------------------ Insert Balance Feeds -------------------------
4283: --

Line 4303: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',70);

4299: p_element_type_id => dedn_ele_ids(1),
4300: p_date => g_eff_start_date);
4301:
4302:
4303: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',70);
4304:
4305: /* *** WITHHOLDING AND CALCULATOR FEEDS SECTION BEGIN *** */
4306:
4307: dedn_base_feed_iv_id(1) := dedn_payval_id(1); -- Base Payval to

Line 4411: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',90);

4407: p_eff_date => g_eff_start_date );
4408:
4409: if ALREADY_EXISTS = 0 then
4410:
4411: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',90);
4412:
4413: hr_balances.ins_balance_feed(
4414: p_option => 'INS_MANUAL_FEED',
4415: p_input_value_id => dedn_base_feed_iv_id(y),