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_US_GARN_GEN dependencies on HR_UTILITY

Line 609: hr_utility.trace('UPGRADE MODE = YES');

605: -- Set upgrade mode flag for addition of input values, link input values, entry values,
606: -- and run result values.
607:
608: l_upgrade_mode := 'Y';
609: hr_utility.trace('UPGRADE MODE = YES');
610:
611: end if;
612:
613: ret := already_exists;

Line 758: hr_utility.trace('In do_defined_balances');

754: num_suffixes := 32;
755:
756: /* WWBug 133133, 350540 finish */
757:
758: hr_utility.trace('In do_defined_balances');
759: for i in 1..num_suffixes loop
760:
761: select dimension_name, balance_dimension_id
762: into dim_name, dim_id

Line 772: hr_utility.trace('Defined Balance for '||p_bal_name||suffixes(i));

768: /* added line to include business_group_id in the where clause of the select
769: statement below. So that it checkes the existence of data for a the given
770: business_group_id Bug No: 502307.
771: */
772: hr_utility.trace('Defined Balance for '||p_bal_name||suffixes(i));
773: SELECT count(0)
774: INTO already_exists
775: FROM pay_defined_balances db
776: WHERE db.balance_type_id = p_bal_id

Line 814: hr_utility.trace('Out of do_defined_balances');

810:
811: end if;
812:
813: end loop;
814: hr_utility.trace('Out of do_defined_balances');
815: END do_defined_balances;
816: --
817: ------------------------- ins_formula -----------------------
818: --

Line 877: hr_utility.set_location('hr_us_garn_gen.ins_formula',20);

873: -- Call function to check existence of formula to get id.
874: -- Get original formula id, name, and text for this element currently,
875: -- ie. before putting in new ff text.
876:
877: hr_utility.set_location('hr_us_garn_gen.ins_formula',20);
878:
879: already_exists := hr_template_existence.ele_ff_exists(
880: p_ele_name => p_ff_ele_name,
881: p_bg_id => p_ff_bg_id,

Line 900: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);

896:
897: --
898: -- Insert the new formula into current business group:
899: --
900: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
901: INSERT INTO ff_formulas_f (
902: FORMULA_ID,
903: EFFECTIVE_START_DATE,
904: EFFECTIVE_END_DATE,

Line 940: hr_utility.set_location('hr_us_garn_gen.ins_formula',50);

936: -- Element already has formula attached via stat proc rule...
937: -- original formula name and text have been populated as outputs
938: -- from check for existence.
939:
940: hr_utility.set_location('hr_us_garn_gen.ins_formula',50);
941:
942: v_new_ele_formula_id := already_exists;
943: v_new_ele_formula_name := v_orig_ele_formula_name;
944:

Line 950: hr_utility.set_location('hr_us_garn_gen.ins_formula',70);

946:
947: -- dbms_output.put_line('existing FF '||v_new_ele_formula_id||' being updated');
948: -- dbms_output.put_line(v_new_ele_formula_name);
949:
950: hr_utility.set_location('hr_us_garn_gen.ins_formula',70);
951:
952: UPDATE ff_formulas_f
953: SET formula_text = v_new_ele_formula_text
954: WHERE formula_id = v_new_ele_formula_id

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

958:
959: --
960: -- Insert the original formula into current business group to preserve customer mods.
961: --
962: hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
963:
964: select count(0)
965: into l_count_already
966: from ff_formulas_f fff, ff_formula_types ffft

Line 976: hr_utility.set_location('hr_us_garn_gen.ins_formula',35);

972: and fff.legislation_code = 'US'
973: and ffft.formula_type_name = 'Oracle Payroll'
974: and ffft.formula_type_id = fff.formula_type_id;
975:
976: hr_utility.set_location('hr_us_garn_gen.ins_formula',35);
977:
978: hr_utility.trace('Preserving text for formula '||v_orig_ele_formula_name ||
979: ' for BG ' || p_ff_bg_id);
980:

Line 978: hr_utility.trace('Preserving text for formula '||v_orig_ele_formula_name ||

974: and ffft.formula_type_id = fff.formula_type_id;
975:
976: hr_utility.set_location('hr_us_garn_gen.ins_formula',35);
977:
978: hr_utility.trace('Preserving text for formula '||v_orig_ele_formula_name ||
979: ' for BG ' || p_ff_bg_id);
980:
981: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
982: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);

Line 984: hr_utility.trace('Text saved in formula named '||v_orig_ele_formula_name);

980:
981: v_orig_ele_formula_name := 'OLD'||l_count_already||'_'||v_orig_ele_formula_name;
982: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
983:
984: hr_utility.trace('Text saved in formula named '||v_orig_ele_formula_name);
985:
986: hr_utility.set_location('hr_us_garn_gen.ins_formula',30);
987:
988: SELECT ff_formulas_s.nextval

Line 986: hr_utility.set_location('hr_us_garn_gen.ins_formula',30);

982: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
983:
984: hr_utility.trace('Text saved in formula named '||v_orig_ele_formula_name);
985:
986: hr_utility.set_location('hr_us_garn_gen.ins_formula',30);
987:
988: SELECT ff_formulas_s.nextval
989: INTO v_orig_ele_formula_id
990: FROM sys.dual;

Line 992: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);

988: SELECT ff_formulas_s.nextval
989: INTO v_orig_ele_formula_id
990: FROM sys.dual;
991:
992: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
993:
994: INSERT INTO ff_formulas_f ( FORMULA_ID,
995: EFFECTIVE_START_DATE,
996: EFFECTIVE_END_DATE,

Line 1039: -- hr_utility.trace_on(null,'ORACLE');

1035: -- Create Garnishment MAIN
1036: --
1037:
1038: BEGIN
1039: -- hr_utility.trace_on(null,'ORACLE');
1040: begin
1041:
1042: select name
1043: into v_bg_name

Line 1048: hr_utility.set_location('Could not find ''BG NAME'' ', 999);

1044: from per_business_groups
1045: where business_group_id + 0 = p_bg_id;
1046: exception WHEN NO_DATA_FOUND THEN
1047: v_bg_name := NULL;
1048: hr_utility.set_location('Could not find ''BG NAME'' ', 999);
1049: end;
1050:
1051: g_eff_start_date := nvl(p_ele_eff_start_date, sysdate);
1052:

Line 1062: hr_utility.set_location('Could not find ''CLASSIFICATION'' ', 999);

1058: from pay_element_classifications
1059: where UPPER(classification_name) = g_ele_classification
1060: and legislation_code = 'US';
1061: exception WHEN NO_DATA_FOUND THEN
1062: hr_utility.set_location('Could not find ''CLASSIFICATION'' ', 999);
1063: end;
1064:
1065: -- Need skip rule formula
1066: begin

Line 1076: hr_utility.set_location('Could not find ''SKIP RULE'' ', 999);

1072: AND legislation_code = 'US'
1073: AND p_ele_eff_start_date >= FF.effective_start_date
1074: AND p_ele_eff_start_date <= FF.effective_end_date;
1075: exception WHEN NO_DATA_FOUND THEN
1076: hr_utility.set_location('Could not find ''SKIP RULE'' ', 999);
1077: end;
1078: -- Get voluntary deductions high level balance for future ref.
1079:
1080: begin

Line 1093: hr_utility.set_location('Could not find ''Voluntary Deductions'' balance', 999);

1089: exception WHEN NO_DATA_FOUND THEN
1090:
1091: g_voldedns_balance_id := NULL;
1092:
1093: hr_utility.set_location('Could not find ''Voluntary Deductions'' balance', 999);
1094:
1095: end;
1096:
1097: -- 374743 : Spousal support and alimony are treated same as child support.

Line 1115: hr_utility.set_location('Could not find ''Total Dedns'' balance', 999);

1111: exception WHEN NO_DATA_FOUND THEN
1112:
1113: g_total_dedns_balance_id := NULL;
1114:
1115: hr_utility.set_location('Could not find ''Total Dedns'' balance', 999);
1116:
1117: end;
1118:
1119: -- Get garnishment "total fees" balance for future ref.

Line 1134: hr_utility.set_location('Could not find ''Total Fees'' balance', 999);

1130: exception WHEN NO_DATA_FOUND THEN
1131:
1132: g_total_fees_balance_id := NULL;
1133:
1134: hr_utility.set_location('Could not find ''Total Fees'' balance', 999);
1135:
1136: end;
1137:
1138: -- Get Other Garn Not Taken Amount balance for future ref.

Line 1149: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));

1145: WHERE balance_name = 'Other Garn Not Taken Amount'
1146: AND business_group_id IS NULL
1147: AND legislation_code = 'US';
1148:
1149: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
1150:
1151: exception WHEN NO_DATA_FOUND THEN
1152:
1153: g_other_not_taken_bal_id := NULL;

Line 1155: hr_utility.set_location('Could not find ''Other Wage Attach Not Taken Amount'' balance'

1151: exception WHEN NO_DATA_FOUND THEN
1152:
1153: g_other_not_taken_bal_id := NULL;
1154:
1155: hr_utility.set_location('Could not find ''Other Wage Attach Not Taken Amount'' balance'
1156: , 999);
1157:
1158: end;
1159:

Line 1179: hr_utility.set_location('Could not find ''Tax Levies'' balance', 999);

1175: exception WHEN NO_DATA_FOUND THEN
1176:
1177: g_tax_levies_balance_id := NULL;
1178:
1179: hr_utility.set_location('Could not find ''Tax Levies'' balance', 999);
1180:
1181: end;
1182:
1183: end if;

Line 1205: hr_utility.set_location('Could not find ''Count'' balance', 999);

1201: exception WHEN NO_DATA_FOUND THEN
1202:
1203: g_childsupp_count_balance_id := NULL;
1204:
1205: hr_utility.set_location('Could not find ''Count'' balance', 999);
1206:
1207: end;
1208:
1209: -- Get child support "total dedns" balance for future ref.

Line 1224: hr_utility.set_location('Could not find ''Total Dedns'' balance', 999);

1220: exception WHEN NO_DATA_FOUND THEN
1221:
1222: g_total_dedns_balance_id := NULL;
1223:
1224: hr_utility.set_location('Could not find ''Total Dedns'' balance', 999);
1225:
1226: end;
1227:
1228: -- Get child support "total amount" balance for future ref.

Line 1243: hr_utility.set_location('Could not find ''Total Amount'' balance', 999);

1239: exception WHEN NO_DATA_FOUND THEN
1240:
1241: g_total_amount_balance_id := NULL;
1242:
1243: hr_utility.set_location('Could not find ''Total Amount'' balance', 999);
1244:
1245: end;
1246:
1247: -- Get support not taken amount balance for future ref.

Line 1262: hr_utility.set_location('Could not find ''Support Not Taken Amount'' balance', 999);

1258: exception WHEN NO_DATA_FOUND THEN
1259:
1260: g_supp_not_taken_bal_id := NULL;
1261:
1262: hr_utility.set_location('Could not find ''Support Not Taken Amount'' balance', 999);
1263:
1264: end;
1265:
1266:

Line 1282: hr_utility.set_location('Could not find ''Total Fees'' balance', 999);

1278: exception WHEN NO_DATA_FOUND THEN
1279:
1280: g_total_fees_balance_id := NULL;
1281:
1282: hr_utility.set_location('Could not find ''Total Fees'' balance', 999);
1283:
1284: end;
1285:
1286: /* 378699 fixes begin */

Line 1302: hr_utility.set_location('Could not find ''Total Withheld Support'' balance', 999);

1298: exception WHEN NO_DATA_FOUND THEN
1299:
1300: g_wh_support_balance_id := NULL;
1301:
1302: hr_utility.set_location('Could not find ''Total Withheld Support'' balance', 999);
1303:
1304: end;
1305:
1306: -- Get wage attach "total adjusted support" balance for future ref.

Line 1321: hr_utility.set_location('Could not find ''Total Withheld Fee'' balance', 999);

1317: exception WHEN NO_DATA_FOUND THEN
1318:
1319: g_wh_fee_balance_id := NULL;
1320:
1321: hr_utility.set_location('Could not find ''Total Withheld Fee'' balance', 999);
1322:
1323: end;
1324: /* 378699 fixes end */
1325:

Line 1349: hr_utility.set_location('MAJOR ERROR: Net or Payments STU balance not found', 999);

1345:
1346: g_net_balance_id := NULL;
1347: g_payments_balance_id := null;
1348:
1349: hr_utility.set_location('MAJOR ERROR: Net or Payments STU balance not found', 999);
1350:
1351: end;
1352:
1353: -- Setup all configuration param settings based on category:

Line 2394: hr_utility.trace('Before do_defined_balances');

2390: garn_assoc_bal_ids(i) := already_exists;
2391:
2392: end if;
2393:
2394: hr_utility.trace('Before do_defined_balances');
2395: if garn_assoc_bal_names(i) in (p_garn_name||' Additional',
2396: p_garn_name||' Replacement',
2397: p_garn_name||' Vol Dedns',
2398: p_garn_name||' Accrued Fees') then

Line 2413: hr_utility.trace('After do_defined_balances');

2409: p_save_run_value => 'Y');
2410:
2411: end if;
2412:
2413: hr_utility.trace('After do_defined_balances');
2414:
2415: END LOOP;
2416:
2417: --

Line 2448: hr_utility.trace('Error here...');

2444: SET mandatory_flag = 'X'
2445: WHERE element_type_id = v_ele_type_id
2446: AND name = v_pay_value_name;
2447: if sql%notfound then
2448: hr_utility.trace('Error here...');
2449: end if;
2450: end;
2451:
2452: begin

Line 2463: hr_utility.trace('Error here...'||to_char(v_ele_type_id));

2459: and effective_end_date; /*1498260*/
2460:
2461: exception
2462: when no_data_found then
2463: hr_utility.trace('Error here...'||to_char(v_ele_type_id));
2464: end;
2465:
2466: garn_payval_id(i) := v_payval_id;
2467:

Line 2500: hr_utility.set_location('Error : DID NOT FIND CALC FORMULA', 9);

2496: exception WHEN NO_DATA_FOUND THEN
2497:
2498: v_calc_formula_id := NULL;
2499:
2500: hr_utility.set_location('Error : DID NOT FIND CALC FORMULA', 9);
2501:
2502: end;
2503:
2504: hr_utility.set_location('ele '||v_ele_type_id||'ff '||v_calc_formula_id||'bg '||p_bg_id, 9);

Line 2504: hr_utility.set_location('ele '||v_ele_type_id||'ff '||v_calc_formula_id||'bg '||p_bg_id, 9);

2500: hr_utility.set_location('Error : DID NOT FIND CALC FORMULA', 9);
2501:
2502: end;
2503:
2504: hr_utility.set_location('ele '||v_ele_type_id||'ff '||v_calc_formula_id||'bg '||p_bg_id, 9);
2505:
2506: -- Looks to require a change here since Alimony and Spousal support verifiers
2507: -- will already have a stat proc rule but not with the new verif formula now put
2508: -- on spousal and alimony...change the spr_exists fn to not use ff id...return ff of

Line 2563: hr_utility.trace('Base ivs = '||to_char(l_num_base_ivs));

2559:
2560: --
2561: -- Now create all base element input values.
2562: --
2563: hr_utility.trace('Base ivs = '||to_char(l_num_base_ivs));
2564: FOR k in 1..l_num_base_ivs LOOP
2565: hr_utility.trace('Base iv # = '||to_char(k));
2566: already_exists := hr_template_existence.iv_name_exists(
2567: p_ele_id => garn_ele_ids(1),

Line 2565: hr_utility.trace('Base iv # = '||to_char(k));

2561: -- Now create all base element input values.
2562: --
2563: hr_utility.trace('Base ivs = '||to_char(l_num_base_ivs));
2564: FOR k in 1..l_num_base_ivs LOOP
2565: hr_utility.trace('Base iv # = '||to_char(k));
2566: already_exists := hr_template_existence.iv_name_exists(
2567: p_ele_id => garn_ele_ids(1),
2568: p_bg_id => p_bg_id,
2569: p_iv_name => garn_base_iv_names(k),

Line 2733: hr_utility.trace('Calc ivs = '||to_char(l_num_calc_ivs));

2729:
2730: --
2731: -- Now create all calc element input values.
2732: --
2733: hr_utility.trace('Calc ivs = '||to_char(l_num_calc_ivs));
2734: FOR c in 1..l_num_calc_ivs LOOP
2735: hr_utility.trace('Calc iv # = '||to_char(c));
2736: already_exists := hr_template_existence.iv_name_exists(
2737: p_ele_id => garn_ele_ids(2),

Line 2735: hr_utility.trace('Calc iv # = '||to_char(c));

2731: -- Now create all calc element input values.
2732: --
2733: hr_utility.trace('Calc ivs = '||to_char(l_num_calc_ivs));
2734: FOR c in 1..l_num_calc_ivs LOOP
2735: hr_utility.trace('Calc iv # = '||to_char(c));
2736: already_exists := hr_template_existence.iv_name_exists(
2737: p_ele_id => garn_ele_ids(2),
2738: p_bg_id => p_bg_id,
2739: p_iv_name => garn_calc_iv_names(c),

Line 2896: hr_utility.trace('Verif ivs = '||to_char(l_num_verif_ivs));

2892:
2893: --
2894: -- Now create all verification element input values.
2895: --
2896: hr_utility.trace('Verif ivs = '||to_char(l_num_verif_ivs));
2897: FOR v in 1..l_num_verif_ivs LOOP
2898: hr_utility.trace('Verif iv # = '||to_char(v));
2899:
2900: already_exists := hr_template_existence.iv_name_exists(

Line 2898: hr_utility.trace('Verif iv # = '||to_char(v));

2894: -- Now create all verification element input values.
2895: --
2896: hr_utility.trace('Verif ivs = '||to_char(l_num_verif_ivs));
2897: FOR v in 1..l_num_verif_ivs LOOP
2898: hr_utility.trace('Verif iv # = '||to_char(v));
2899:
2900: already_exists := hr_template_existence.iv_name_exists(
2901: p_ele_id => garn_ele_ids(3),
2902: p_bg_id => p_bg_id,

Line 3060: hr_utility.trace('SIV ivs = '||to_char(l_num_si_ivs));

3056:
3057: --
3058: -- Now create all special inputs element input values.
3059: --
3060: hr_utility.trace('SIV ivs = '||to_char(l_num_si_ivs));
3061: FOR siv in 1..l_num_si_ivs LOOP
3062: hr_utility.trace('SIV iv # = '||to_char(siv));
3063: already_exists := hr_template_existence.iv_name_exists(
3064: p_ele_id => garn_ele_ids(4),

Line 3062: hr_utility.trace('SIV iv # = '||to_char(siv));

3058: -- Now create all special inputs element input values.
3059: --
3060: hr_utility.trace('SIV ivs = '||to_char(l_num_si_ivs));
3061: FOR siv in 1..l_num_si_ivs LOOP
3062: hr_utility.trace('SIV iv # = '||to_char(siv));
3063: already_exists := hr_template_existence.iv_name_exists(
3064: p_ele_id => garn_ele_ids(4),
3065: p_bg_id => p_bg_id,
3066: p_iv_name => garn_si_iv_names(siv),

Line 3224: hr_utility.trace('SFV ivs = '||to_char(l_num_sf_ivs));

3220:
3221: --
3222: -- Now create all special features element input values.
3223: --
3224: hr_utility.trace('SFV ivs = '||to_char(l_num_sf_ivs));
3225: FOR sfv in 1..l_num_sf_ivs LOOP
3226: hr_utility.trace('SFV iv # = '||to_char(sfv));
3227:
3228: already_exists := hr_template_existence.iv_name_exists(

Line 3226: hr_utility.trace('SFV iv # = '||to_char(sfv));

3222: -- Now create all special features element input values.
3223: --
3224: hr_utility.trace('SFV ivs = '||to_char(l_num_sf_ivs));
3225: FOR sfv in 1..l_num_sf_ivs LOOP
3226: hr_utility.trace('SFV iv # = '||to_char(sfv));
3227:
3228: already_exists := hr_template_existence.iv_name_exists(
3229: p_ele_id => garn_ele_ids(5),
3230: p_bg_id => p_bg_id,

Line 3388: hr_utility.trace('Fee ivs = '||to_char(l_num_fee_ivs));

3384:
3385: --
3386: -- Now create all fee element input values.
3387: --
3388: hr_utility.trace('Fee ivs = '||to_char(l_num_fee_ivs));
3389: FOR lfee in 1..l_num_fee_ivs LOOP
3390: hr_utility.trace('Fees iv # = '||to_char(lfee));
3391: already_exists := hr_template_existence.iv_name_exists(
3392: p_ele_id => garn_ele_ids(6),

Line 3390: hr_utility.trace('Fees iv # = '||to_char(lfee));

3386: -- Now create all fee element input values.
3387: --
3388: hr_utility.trace('Fee ivs = '||to_char(l_num_fee_ivs));
3389: FOR lfee in 1..l_num_fee_ivs LOOP
3390: hr_utility.trace('Fees iv # = '||to_char(lfee));
3391: already_exists := hr_template_existence.iv_name_exists(
3392: p_ele_id => garn_ele_ids(6),
3393: p_bg_id => p_bg_id,
3394: p_iv_name => garn_fee_iv_names(lfee),

Line 3550: hr_utility.trace('VP ivs = '||to_char(l_num_vp_ivs));

3546: END LOOP;
3547:
3548: -- Now create all verifier priority element input values.
3549: --
3550: hr_utility.trace('VP ivs = '||to_char(l_num_vp_ivs));
3551: FOR lvp in 1..l_num_vp_ivs LOOP
3552: hr_utility.trace('VP iv # = '||to_char(lvp));
3553: already_exists := hr_template_existence.iv_name_exists(
3554: p_ele_id => garn_ele_ids(7),

Line 3552: hr_utility.trace('VP iv # = '||to_char(lvp));

3548: -- Now create all verifier priority element input values.
3549: --
3550: hr_utility.trace('VP ivs = '||to_char(l_num_vp_ivs));
3551: FOR lvp in 1..l_num_vp_ivs LOOP
3552: hr_utility.trace('VP iv # = '||to_char(lvp));
3553: already_exists := hr_template_existence.iv_name_exists(
3554: p_ele_id => garn_ele_ids(7),
3555: p_bg_id => p_bg_id,
3556: p_iv_name => garn_vp_iv_names(lvp),

Line 4080: hr_utility.trace('After inserting Calculated fee for non supported elements');

4076: l_num_calc_resrules := 27;
4077:
4078: END IF;
4079:
4080: hr_utility.trace('After inserting Calculated fee for non supported elements');
4081: garn_verif_frr_name(1) := 'WH_DEDN_AMT';
4082: garn_verif_frr_type(1) := 'I';
4083: garn_verif_frr_iv_id(1) := garn_payval_id(1);
4084: garn_verif_frr_ele_id(1) := garn_ele_ids(1);

Line 4256: hr_utility.set_location('Here', 1);

4252:
4253:
4254: -- Formula Result Rules for BASE ELEMENT
4255: -- ie. garn_statproc_rule_id(1)
4256: hr_utility.set_location('Here', 1);
4257: delete from pay_formula_result_rules_f
4258: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(1);
4259:
4260: hr_utility.set_location('Here', 2);

Line 4260: hr_utility.set_location('Here', 2);

4256: hr_utility.set_location('Here', 1);
4257: delete from pay_formula_result_rules_f
4258: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(1);
4259:
4260: hr_utility.set_location('Here', 2);
4261: FOR n in 1..l_num_base_resrules LOOP
4262:
4263:
4264: already_exists := hr_template_existence.result_rule_exists(

Line 4272: hr_utility.set_location('Here', 3);

4268: p_bg_id => p_bg_id,
4269: p_ele_id => garn_base_frr_ele_id(n),
4270: p_eff_date => g_eff_start_date);
4271:
4272: hr_utility.set_location('Here', 3);
4273: if already_exists = 0 then
4274:
4275: hr_utility.set_location('Here', 4);
4276: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

Line 4275: hr_utility.set_location('Here', 4);

4271:
4272: hr_utility.set_location('Here', 3);
4273: if already_exists = 0 then
4274:
4275: hr_utility.set_location('Here', 4);
4276: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
4277: p_business_group_id => p_bg_id,
4278: p_legislation_code => NULL,
4279: p_legislation_subgroup => g_template_leg_subgroup,

Line 4288: hr_utility.set_location('Here', 5);

4284: p_result_name => garn_base_frr_name(n),
4285: p_result_rule_type => garn_base_frr_type(n),
4286: p_severity_level => garn_base_frr_severity(n),
4287: p_element_type_id => garn_base_frr_ele_id(n));
4288: hr_utility.set_location('Here', 5);
4289:
4290: else
4291:
4292: hr_utility.set_location('Here', 6);

Line 4292: hr_utility.set_location('Here', 6);

4288: hr_utility.set_location('Here', 5);
4289:
4290: else
4291:
4292: hr_utility.set_location('Here', 6);
4293: v_fres_rule_id := already_exists;
4294:
4295: end if;
4296:

Line 4301: hr_utility.set_location('Here', 7);

4297: END LOOP;
4298:
4299: -- Formula Result Rules for CALCULATION ELEMENT
4300: -- ie. garn_statproc_rule_id(2)
4301: hr_utility.set_location('Here', 7);
4302: delete from pay_formula_result_rules_f
4303: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(2);
4304:
4305: hr_utility.set_location('Here', 8);

Line 4305: hr_utility.set_location('Here', 8);

4301: hr_utility.set_location('Here', 7);
4302: delete from pay_formula_result_rules_f
4303: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(2);
4304:
4305: hr_utility.set_location('Here', 8);
4306: FOR o in 1..l_num_calc_resrules LOOP
4307:
4308: hr_utility.set_location('Here', 9);
4309: already_exists := hr_template_existence.result_rule_exists(

Line 4308: hr_utility.set_location('Here', 9);

4304:
4305: hr_utility.set_location('Here', 8);
4306: FOR o in 1..l_num_calc_resrules LOOP
4307:
4308: hr_utility.set_location('Here', 9);
4309: already_exists := hr_template_existence.result_rule_exists(
4310: p_spr_id => garn_statproc_rule_id(2),
4311: p_frr_name => garn_calc_frr_name(o),
4312: p_iv_id => garn_calc_frr_iv_id(o),

Line 4319: hr_utility.set_location('Here', 10);

4315: p_eff_date => g_eff_start_date);
4316:
4317: if already_exists = 0 then
4318:
4319: hr_utility.set_location('Here', 10);
4320:
4321: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
4322: p_business_group_id => p_bg_id,
4323: p_legislation_code => NULL,

Line 4334: hr_utility.set_location('Here', 11);

4330: p_result_rule_type => garn_calc_frr_type(o),
4331: p_severity_level => garn_calc_frr_severity(o),
4332: p_element_type_id => garn_calc_frr_ele_id(o));
4333:
4334: hr_utility.set_location('Here', 11);
4335: else
4336:
4337: v_fres_rule_id := already_exists;
4338:

Line 4339: hr_utility.set_location('Here', 12);

4335: else
4336:
4337: v_fres_rule_id := already_exists;
4338:
4339: hr_utility.set_location('Here', 12);
4340: end if;
4341:
4342: END LOOP;
4343: hr_utility.set_location('Here', 13);

Line 4343: hr_utility.set_location('Here', 13);

4339: hr_utility.set_location('Here', 12);
4340: end if;
4341:
4342: END LOOP;
4343: hr_utility.set_location('Here', 13);
4344:
4345: -- Formula Result Rules for VERIFIER PRIORITY ELEMENT
4346: -- ie. garn_statproc_rule_id(7)
4347: IF p_category in ('CS', 'SS', 'AY') THEN

Line 4348: hr_utility.set_location('Here', 14);

4344:
4345: -- Formula Result Rules for VERIFIER PRIORITY ELEMENT
4346: -- ie. garn_statproc_rule_id(7)
4347: IF p_category in ('CS', 'SS', 'AY') THEN
4348: hr_utility.set_location('Here', 14);
4349: delete from pay_formula_result_rules_f
4350: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(7);
4351: hr_utility.set_location('Here', 15);
4352:

Line 4351: hr_utility.set_location('Here', 15);

4347: IF p_category in ('CS', 'SS', 'AY') THEN
4348: hr_utility.set_location('Here', 14);
4349: delete from pay_formula_result_rules_f
4350: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(7);
4351: hr_utility.set_location('Here', 15);
4352:
4353: FOR o in 1..l_num_vp_resrules LOOP
4354:
4355: hr_utility.set_location('Here', 16);

Line 4355: hr_utility.set_location('Here', 16);

4351: hr_utility.set_location('Here', 15);
4352:
4353: FOR o in 1..l_num_vp_resrules LOOP
4354:
4355: hr_utility.set_location('Here', 16);
4356: already_exists := hr_template_existence.result_rule_exists(
4357: p_spr_id => garn_statproc_rule_id(7),
4358: p_frr_name => garn_vp_frr_name(o),
4359: p_iv_id => garn_vp_frr_iv_id(o),

Line 4366: hr_utility.set_location('Here', 17);

4362: p_eff_date => g_eff_start_date);
4363:
4364: if already_exists = 0 then
4365:
4366: hr_utility.set_location('Here', 17);
4367: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
4368: p_business_group_id => p_bg_id,
4369: p_legislation_code => NULL,
4370: p_legislation_subgroup => g_template_leg_subgroup,

Line 4380: hr_utility.set_location('Here', 18);

4376: p_result_rule_type => garn_vp_frr_type(o),
4377: p_severity_level => garn_vp_frr_severity(o),
4378: p_element_type_id => garn_vp_frr_ele_id(o));
4379:
4380: hr_utility.set_location('Here', 18);
4381: else
4382:
4383: v_fres_rule_id := already_exists;
4384: hr_utility.set_location('Here', 19);

Line 4384: hr_utility.set_location('Here', 19);

4380: hr_utility.set_location('Here', 18);
4381: else
4382:
4383: v_fres_rule_id := already_exists;
4384: hr_utility.set_location('Here', 19);
4385:
4386: end if;
4387:
4388: END LOOP;

Line 4391: hr_utility.set_location('Here', 20);

4387:
4388: END LOOP;
4389: end if;
4390:
4391: hr_utility.set_location('Here', 20);
4392: -- Formula Result Rules for VERIFIER ELEMENT
4393: -- ie. garn_statproc_rule_id(3) , only required for support orders...
4394: IF p_category in ('CS', 'SS', 'AY') THEN
4395: hr_utility.set_location('Here', 21);

Line 4395: hr_utility.set_location('Here', 21);

4391: hr_utility.set_location('Here', 20);
4392: -- Formula Result Rules for VERIFIER ELEMENT
4393: -- ie. garn_statproc_rule_id(3) , only required for support orders...
4394: IF p_category in ('CS', 'SS', 'AY') THEN
4395: hr_utility.set_location('Here', 21);
4396: delete from pay_formula_result_rules_f
4397: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(3);
4398:
4399: FOR p in 1..l_num_verif_resrules LOOP

Line 4401: hr_utility.set_location('Here', 22);

4397: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(3);
4398:
4399: FOR p in 1..l_num_verif_resrules LOOP
4400:
4401: hr_utility.set_location('Here', 22);
4402: already_exists := hr_template_existence.result_rule_exists(
4403: p_spr_id => garn_statproc_rule_id(3),
4404: p_frr_name => garn_verif_frr_name(p),
4405: p_iv_id => garn_verif_frr_iv_id(p),

Line 4410: hr_utility.set_location('Here', 23);

4406: p_bg_id => p_bg_id,
4407: p_ele_id => garn_verif_frr_ele_id(p),
4408: p_eff_date => g_eff_start_date);
4409:
4410: hr_utility.set_location('Here', 23);
4411: if already_exists = 0 then
4412:
4413: hr_utility.set_location('Here', 24);
4414: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

Line 4413: hr_utility.set_location('Here', 24);

4409:
4410: hr_utility.set_location('Here', 23);
4411: if already_exists = 0 then
4412:
4413: hr_utility.set_location('Here', 24);
4414: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
4415: p_business_group_id => p_bg_id,
4416: p_legislation_code => NULL,
4417: p_legislation_subgroup => g_template_leg_subgroup,

Line 4430: hr_utility.set_location('Here', 25);

4426:
4427: else
4428:
4429: v_fres_rule_id := already_exists;
4430: hr_utility.set_location('Here', 25);
4431:
4432: end if;
4433:
4434: END LOOP;

Line 4596: hr_utility.trace('Base Feeds : '||to_char(l_num_base_feeds));

4592:
4593: END IF;
4594:
4595:
4596: hr_utility.trace('Base Feeds : '||to_char(l_num_base_feeds));
4597:
4598: FOR i in 1..l_num_base_feeds LOOP
4599:
4600: IF garn_base_feed_iv_id(i) IS NOT NULL THEN

Line 4602: hr_utility.trace('Bal Id : '||to_char(garn_base_feed_bal_id(i)));

4598: FOR i in 1..l_num_base_feeds LOOP
4599:
4600: IF garn_base_feed_iv_id(i) IS NOT NULL THEN
4601:
4602: hr_utility.trace('Bal Id : '||to_char(garn_base_feed_bal_id(i)));
4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));
4605: hr_utility.trace('Date : '||g_eff_start_date);
4606:

Line 4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4599:
4600: IF garn_base_feed_iv_id(i) IS NOT NULL THEN
4601:
4602: hr_utility.trace('Bal Id : '||to_char(garn_base_feed_bal_id(i)));
4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));
4605: hr_utility.trace('Date : '||g_eff_start_date);
4606:
4607: already_exists := hr_template_existence.bal_feed_exists (

Line 4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));

4600: IF garn_base_feed_iv_id(i) IS NOT NULL THEN
4601:
4602: hr_utility.trace('Bal Id : '||to_char(garn_base_feed_bal_id(i)));
4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));
4605: hr_utility.trace('Date : '||g_eff_start_date);
4606:
4607: already_exists := hr_template_existence.bal_feed_exists (
4608: p_bal_id => garn_base_feed_bal_id(i),

Line 4605: hr_utility.trace('Date : '||g_eff_start_date);

4601:
4602: hr_utility.trace('Bal Id : '||to_char(garn_base_feed_bal_id(i)));
4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));
4605: hr_utility.trace('Date : '||g_eff_start_date);
4606:
4607: already_exists := hr_template_existence.bal_feed_exists (
4608: p_bal_id => garn_base_feed_bal_id(i),
4609: p_bg_id => p_bg_id,

Line 4635: hr_utility.trace('SI Feeds : '||to_char(l_num_si_feeds));

4631: END IF;
4632:
4633: END LOOP;
4634:
4635: hr_utility.trace('SI Feeds : '||to_char(l_num_si_feeds));
4636:
4637: FOR sif in 1..l_num_si_feeds LOOP
4638:
4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));

Line 4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));

4635: hr_utility.trace('SI Feeds : '||to_char(l_num_si_feeds));
4636:
4637: FOR sif in 1..l_num_si_feeds LOOP
4638:
4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));
4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));
4642: hr_utility.trace('Date : '||g_eff_start_date);
4643:

Line 4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4636:
4637: FOR sif in 1..l_num_si_feeds LOOP
4638:
4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));
4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));
4642: hr_utility.trace('Date : '||g_eff_start_date);
4643:
4644: already_exists := hr_template_existence.bal_feed_exists (

Line 4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));

4637: FOR sif in 1..l_num_si_feeds LOOP
4638:
4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));
4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));
4642: hr_utility.trace('Date : '||g_eff_start_date);
4643:
4644: already_exists := hr_template_existence.bal_feed_exists (
4645: p_bal_id => garn_si_feed_bal_id(sif),

Line 4642: hr_utility.trace('Date : '||g_eff_start_date);

4638:
4639: hr_utility.trace('Bal Id : '||to_char(garn_si_feed_bal_id(sif)));
4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));
4642: hr_utility.trace('Date : '||g_eff_start_date);
4643:
4644: already_exists := hr_template_existence.bal_feed_exists (
4645: p_bal_id => garn_si_feed_bal_id(sif),
4646: p_bg_id => p_bg_id,

Line 4670: hr_utility.trace('SF Feeds : '||to_char(l_num_sf_feeds));

4666: end if;
4667:
4668: END LOOP;
4669:
4670: hr_utility.trace('SF Feeds : '||to_char(l_num_sf_feeds));
4671:
4672: FOR sf in 1..l_num_sf_feeds LOOP
4673:
4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));

Line 4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));

4670: hr_utility.trace('SF Feeds : '||to_char(l_num_sf_feeds));
4671:
4672: FOR sf in 1..l_num_sf_feeds LOOP
4673:
4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));
4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));

Line 4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));

4671:
4672: FOR sf in 1..l_num_sf_feeds LOOP
4673:
4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));
4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);

Line 4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));

4672: FOR sf in 1..l_num_sf_feeds LOOP
4673:
4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));
4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);
4680:

Line 4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4673:
4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));
4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);
4680:
4681: already_exists := hr_template_existence.bal_feed_exists (

Line 4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));

4674: hr_utility.trace('l_num_sf_feeds = '||to_char(sf));
4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);
4680:
4681: already_exists := hr_template_existence.bal_feed_exists (
4682: p_bal_id => garn_sf_feed_bal_id(sf),

Line 4679: hr_utility.trace('Date : '||g_eff_start_date);

4675: hr_utility.trace('g_other_not_taken_bal_id = '||to_char(g_other_not_taken_bal_id));
4676: hr_utility.trace('Bal Id : '||to_char(garn_sf_feed_bal_id(sf)));
4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);
4680:
4681: already_exists := hr_template_existence.bal_feed_exists (
4682: p_bal_id => garn_sf_feed_bal_id(sf),
4683: p_bg_id => p_bg_id,

Line 4708: hr_utility.trace('Calc Feeds : '||to_char(l_num_calc_feeds));

4704:
4705: END LOOP;
4706:
4707: /*
4708: hr_utility.trace('Calc Feeds : '||to_char(l_num_calc_feeds));
4709:
4710: FOR scf in 1..l_num_calc_feeds LOOP
4711:
4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));

Line 4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));

4708: hr_utility.trace('Calc Feeds : '||to_char(l_num_calc_feeds));
4709:
4710: FOR scf in 1..l_num_calc_feeds LOOP
4711:
4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));
4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));
4715: hr_utility.trace('Date : '||g_eff_start_date);
4716:

Line 4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4709:
4710: FOR scf in 1..l_num_calc_feeds LOOP
4711:
4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));
4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));
4715: hr_utility.trace('Date : '||g_eff_start_date);
4716:
4717: already_exists := hr_template_existence.bal_feed_exists(

Line 4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));

4710: FOR scf in 1..l_num_calc_feeds LOOP
4711:
4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));
4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));
4715: hr_utility.trace('Date : '||g_eff_start_date);
4716:
4717: already_exists := hr_template_existence.bal_feed_exists(
4718: p_bal_id => garn_calc_feed_bal_id(scf),

Line 4715: hr_utility.trace('Date : '||g_eff_start_date);

4711:
4712: hr_utility.trace('Bal Id : '||to_char(garn_calc_feed_bal_id(scf)));
4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));
4715: hr_utility.trace('Date : '||g_eff_start_date);
4716:
4717: already_exists := hr_template_existence.bal_feed_exists(
4718: p_bal_id => garn_calc_feed_bal_id(scf),
4719: p_bg_id => p_bg_id,

Line 4743: hr_utility.trace('Verif Feeds : '||to_char(l_num_verif_feeds));

4739: end if;
4740:
4741: END LOOP;
4742:
4743: hr_utility.trace('Verif Feeds : '||to_char(l_num_verif_feeds));
4744:
4745: FOR i in 1..l_num_verif_feeds LOOP
4746:
4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));

Line 4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));

4743: hr_utility.trace('Verif Feeds : '||to_char(l_num_verif_feeds));
4744:
4745: FOR i in 1..l_num_verif_feeds LOOP
4746:
4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));
4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));
4750: hr_utility.trace('Date : '||g_eff_start_date);
4751:

Line 4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4744:
4745: FOR i in 1..l_num_verif_feeds LOOP
4746:
4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));
4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));
4750: hr_utility.trace('Date : '||g_eff_start_date);
4751:
4752: already_exists := hr_template_existence.bal_feed_exists (

Line 4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));

4745: FOR i in 1..l_num_verif_feeds LOOP
4746:
4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));
4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));
4750: hr_utility.trace('Date : '||g_eff_start_date);
4751:
4752: already_exists := hr_template_existence.bal_feed_exists (
4753: p_bal_id => garn_verif_feed_bal_id(i),

Line 4750: hr_utility.trace('Date : '||g_eff_start_date);

4746:
4747: hr_utility.trace('Bal Id : '||to_char(garn_verif_feed_bal_id(sif)));
4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));
4750: hr_utility.trace('Date : '||g_eff_start_date);
4751:
4752: already_exists := hr_template_existence.bal_feed_exists (
4753: p_bal_id => garn_verif_feed_bal_id(i),
4754: p_bg_id => p_bg_id,

Line 4778: hr_utility.trace('Fee Feeds : '||to_char(l_num_fee_feeds));

4774: end if;
4775:
4776: END LOOP;
4777: */
4778: hr_utility.trace('Fee Feeds : '||to_char(l_num_fee_feeds));
4779:
4780: FOR nfee in 1..l_num_fee_feeds LOOP
4781:
4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));

Line 4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));

4778: hr_utility.trace('Fee Feeds : '||to_char(l_num_fee_feeds));
4779:
4780: FOR nfee in 1..l_num_fee_feeds LOOP
4781:
4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));
4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));
4785: hr_utility.trace('Date : '||g_eff_start_date);
4786:

Line 4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4779:
4780: FOR nfee in 1..l_num_fee_feeds LOOP
4781:
4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));
4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));
4785: hr_utility.trace('Date : '||g_eff_start_date);
4786:
4787: already_exists := hr_template_existence.bal_feed_exists (

Line 4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));

4780: FOR nfee in 1..l_num_fee_feeds LOOP
4781:
4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));
4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));
4785: hr_utility.trace('Date : '||g_eff_start_date);
4786:
4787: already_exists := hr_template_existence.bal_feed_exists (
4788: p_bal_id => garn_fee_feed_bal_id(nfee),

Line 4785: hr_utility.trace('Date : '||g_eff_start_date);

4781:
4782: hr_utility.trace('Bal Id : '||to_char(garn_fee_feed_bal_id(nfee)));
4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));
4785: hr_utility.trace('Date : '||g_eff_start_date);
4786:
4787: already_exists := hr_template_existence.bal_feed_exists (
4788: p_bal_id => garn_fee_feed_bal_id(nfee),
4789: p_bg_id => p_bg_id,

Line 4818: hr_utility.trace('Insert feeds for fee amount input val to balances fed by invol dedns');

4814: -- Insert feeds for fee amount input val to balances fed by invol dedns (ie. not automatically
4815: -- created b/c these are not the Fee element Pay Value!).
4816:
4817: OPEN get_invol_bals;
4818: hr_utility.trace('Insert feeds for fee amount input val to balances fed by invol dedns');
4819: LOOP
4820:
4821: FETCH get_invol_bals INTO l_involbal_id, l_invol_scale;
4822: EXIT WHEN get_invol_bals%NOTFOUND;

Line 4824: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));

4820:
4821: FETCH get_invol_bals INTO l_involbal_id, l_invol_scale;
4822: EXIT WHEN get_invol_bals%NOTFOUND;
4823:
4824: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));
4827: hr_utility.trace('Date : '||g_eff_start_date);
4828:

Line 4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4821: FETCH get_invol_bals INTO l_involbal_id, l_invol_scale;
4822: EXIT WHEN get_invol_bals%NOTFOUND;
4823:
4824: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));
4827: hr_utility.trace('Date : '||g_eff_start_date);
4828:
4829: already_exists := hr_template_existence.bal_feed_exists (

Line 4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));

4822: EXIT WHEN get_invol_bals%NOTFOUND;
4823:
4824: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));
4827: hr_utility.trace('Date : '||g_eff_start_date);
4828:
4829: already_exists := hr_template_existence.bal_feed_exists (
4830: p_bal_id => l_involbal_id,

Line 4827: hr_utility.trace('Date : '||g_eff_start_date);

4823:
4824: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));
4827: hr_utility.trace('Date : '||g_eff_start_date);
4828:
4829: already_exists := hr_template_existence.bal_feed_exists (
4830: p_bal_id => l_involbal_id,
4831: p_bg_id => p_bg_id,

Line 4854: hr_utility.trace('Also need to do this for pay value of base element');

4850:
4851: end if;
4852:
4853: -- Also need to do this for pay value of base element, just in case...
4854: hr_utility.trace('Also need to do this for pay value of base element');
4855:
4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));

Line 4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));

4852:
4853: -- Also need to do this for pay value of base element, just in case...
4854: hr_utility.trace('Also need to do this for pay value of base element');
4855:
4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));
4859: hr_utility.trace('Date : '||g_eff_start_date);
4860:

Line 4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));

4853: -- Also need to do this for pay value of base element, just in case...
4854: hr_utility.trace('Also need to do this for pay value of base element');
4855:
4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));
4859: hr_utility.trace('Date : '||g_eff_start_date);
4860:
4861: already_exists := hr_template_existence.bal_feed_exists (

Line 4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));

4854: hr_utility.trace('Also need to do this for pay value of base element');
4855:
4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));
4859: hr_utility.trace('Date : '||g_eff_start_date);
4860:
4861: already_exists := hr_template_existence.bal_feed_exists (
4862: p_bal_id => l_involbal_id,

Line 4859: hr_utility.trace('Date : '||g_eff_start_date);

4855:
4856: hr_utility.trace('Bal Id : '||to_char(l_involbal_id));
4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));
4859: hr_utility.trace('Date : '||g_eff_start_date);
4860:
4861: already_exists := hr_template_existence.bal_feed_exists (
4862: p_bal_id => l_involbal_id,
4863: p_bg_id => p_bg_id,

Line 4915: hr_utility.trace('Before final update Line:4513 garn_assoc_bal_id '|| to_char(garn_assoc_bal_ids(7)));

4911: element_information19 = garn_ele_ids(5),
4912: element_information20 = garn_ele_ids(3)
4913: WHERE element_type_id = garn_ele_ids(1);
4914:
4915: hr_utility.trace('Before final update Line:4513 garn_assoc_bal_id '|| to_char(garn_assoc_bal_ids(7)));
4916: UPDATE pay_element_types_f
4917: SET element_information10 = garn_assoc_bal_ids(7),
4918: element_information11 = garn_assoc_bal_ids(9)
4919: WHERE element_type_id = garn_ele_ids(6);

Line 5156: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5152: -- Do not allow direct deletion of any associated element, these will be
5153: -- deleted by deleting the "base" ele.
5154: --
5155: IF p_ele_name like '% Special Features' THEN
5156: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5157: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5158: hr_utility.raise_error;
5159: END IF;
5160: --

Line 5157: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5153: -- deleted by deleting the "base" ele.
5154: --
5155: IF p_ele_name like '% Special Features' THEN
5156: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5157: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5158: hr_utility.raise_error;
5159: END IF;
5160: --
5161: -- Do not allow deletion of Special Inputs ele, delete by deleting base ele:

Line 5158: hr_utility.raise_error;

5154: --
5155: IF p_ele_name like '% Special Features' THEN
5156: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5157: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5158: hr_utility.raise_error;
5159: END IF;
5160: --
5161: -- Do not allow deletion of Special Inputs ele, delete by deleting base ele:
5162: --

Line 5164: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5160: --
5161: -- Do not allow deletion of Special Inputs ele, delete by deleting base ele:
5162: --
5163: IF p_ele_name like '% Special Inputs' THEN
5164: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5165: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5166: hr_utility.raise_error;
5167: END IF;
5168: --

Line 5165: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5161: -- Do not allow deletion of Special Inputs ele, delete by deleting base ele:
5162: --
5163: IF p_ele_name like '% Special Inputs' THEN
5164: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5165: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5166: hr_utility.raise_error;
5167: END IF;
5168: --
5169: -- Do not allow deletion of Calculator element, delete by deleting base ele:

Line 5166: hr_utility.raise_error;

5162: --
5163: IF p_ele_name like '% Special Inputs' THEN
5164: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5165: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5166: hr_utility.raise_error;
5167: END IF;
5168: --
5169: -- Do not allow deletion of Calculator element, delete by deleting base ele:
5170: --

Line 5172: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5168: --
5169: -- Do not allow deletion of Calculator element, delete by deleting base ele:
5170: --
5171: IF p_ele_name like '% Calculator' THEN
5172: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5173: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5174: hr_utility.raise_error;
5175: END IF;
5176: --

Line 5173: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5169: -- Do not allow deletion of Calculator element, delete by deleting base ele:
5170: --
5171: IF p_ele_name like '% Calculator' THEN
5172: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5173: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5174: hr_utility.raise_error;
5175: END IF;
5176: --
5177: -- Do not allow deletion of Verifier element, delete by deleting base ele:

Line 5174: hr_utility.raise_error;

5170: --
5171: IF p_ele_name like '% Calculator' THEN
5172: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5173: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5174: hr_utility.raise_error;
5175: END IF;
5176: --
5177: -- Do not allow deletion of Verifier element, delete by deleting base ele:
5178: --

Line 5180: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5176: --
5177: -- Do not allow deletion of Verifier element, delete by deleting base ele:
5178: --
5179: IF p_ele_name like '% Verifier' THEN
5180: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5181: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5182: hr_utility.raise_error;
5183: END IF;
5184: --

Line 5181: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5177: -- Do not allow deletion of Verifier element, delete by deleting base ele:
5178: --
5179: IF p_ele_name like '% Verifier' THEN
5180: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5181: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5182: hr_utility.raise_error;
5183: END IF;
5184: --
5185: -- Do not allow deletion of Fees element, delete by deleting base ele:

Line 5182: hr_utility.raise_error;

5178: --
5179: IF p_ele_name like '% Verifier' THEN
5180: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5181: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5182: hr_utility.raise_error;
5183: END IF;
5184: --
5185: -- Do not allow deletion of Fees element, delete by deleting base ele:
5186: --

Line 5188: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5184: --
5185: -- Do not allow deletion of Fees element, delete by deleting base ele:
5186: --
5187: IF p_ele_name like '% Fees' THEN
5188: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5189: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5190: hr_utility.raise_error;
5191: END IF;
5192:

Line 5189: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5185: -- Do not allow deletion of Fees element, delete by deleting base ele:
5186: --
5187: IF p_ele_name like '% Fees' THEN
5188: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5189: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5190: hr_utility.raise_error;
5191: END IF;
5192:
5193: IF p_ele_name like '% Priority' THEN

Line 5190: hr_utility.raise_error;

5186: --
5187: IF p_ele_name like '% Fees' THEN
5188: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5189: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5190: hr_utility.raise_error;
5191: END IF;
5192:
5193: IF p_ele_name like '% Priority' THEN
5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

Line 5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);

5190: hr_utility.raise_error;
5191: END IF;
5192:
5193: IF p_ele_name like '% Priority' THEN
5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5195: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5196: hr_utility.raise_error;
5197: END IF;
5198: --

Line 5195: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');

5191: END IF;
5192:
5193: IF p_ele_name like '% Priority' THEN
5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5195: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5196: hr_utility.raise_error;
5197: END IF;
5198: --
5199: -- Delete base ele frequency rule info:

Line 5196: hr_utility.raise_error;

5192:
5193: IF p_ele_name like '% Priority' THEN
5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5195: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5196: hr_utility.raise_error;
5197: END IF;
5198: --
5199: -- Delete base ele frequency rule info:
5200: --

Line 5291: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 10);

5287:
5288: FETCH get_spr INTO v_spr_id;
5289: EXIT WHEN get_spr%NOTFOUND;
5290:
5291: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 10);
5292: hr_elements.del_status_processing_rules(
5293: p_element_type_id => assoc_eles(i),
5294: p_delete_mode => v_del_mode,
5295: p_val_session_date => v_del_sess_date,

Line 5358: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 50);

5354: FOR i in 1..l_num_assoc_bals LOOP
5355:
5356: IF assoc_bals(i) IS NOT NULL THEN
5357:
5358: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 50);
5359: hr_balances.del_balance_type_cascade (
5360: p_balance_type_id => assoc_bals(i),
5361: p_legislation_code => g_template_leg_code,
5362: p_mode => v_del_mode);

Line 5364: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);

5360: p_balance_type_id => assoc_bals(i),
5361: p_legislation_code => g_template_leg_code,
5362: p_mode => v_del_mode);
5363:
5364: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);
5365: DELETE FROM pay_balance_types
5366: WHERE balance_type_id = assoc_bals(i);
5367:
5368: END IF;

Line 5389: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 20);

5385: where element_type_id = assoc_eles(j)
5386: and v_del_sess_date between effective_start_date
5387: and effective_end_date;
5388:
5389: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 20);
5390: hr_elements.chk_del_element_type (
5391: p_mode => v_del_mode,
5392: p_element_type_id => assoc_eles(j),
5393: p_processing_priority => v_assoc_ele_priority,

Line 5398: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 30);

5394: p_session_date => v_del_sess_date,
5395: p_val_start_date => v_del_val_start,
5396: p_val_end_date => v_del_val_end);
5397:
5398: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 30);
5399: hr_elements.del_3p_element_type (
5400: p_element_type_id => assoc_eles(j),
5401: p_delete_mode => v_del_mode,
5402: p_val_session_date => v_del_sess_date,

Line 5410: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 35);

5406: --
5407: -- Delete element type record:
5408: -- Remember, we're 'ZAP'ing, no need to worry about date-effective delete.
5409: --
5410: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 35);
5411: delete from PAY_ELEMENT_TYPES_F
5412: where element_type_id = assoc_eles(j);
5413:
5414: END IF;

Line 5431: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 45);

5427:
5428: -- Check if the element to be deleted was created using CORE template. If yes
5429: -- delete the template created while creating the element.
5430: if v_template_id is not null then
5431: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 45);
5432: -- Bug 4680388
5433: -- Modified the code to use delete_user_structure
5434: pay_element_template_api.delete_user_structure(
5435: p_drop_formula_packages => TRUE