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.

[Home] [Help]

APPS.PAY_US_GARN_UPGRADE dependencies on HR_UTILITY

Line 182: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');

178: l_cal_formula_name varchar2(100);
179: l_formula_text long;
180: l_new_formula_text long;
181: BEGIN
182: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
183:
184: /*
185: * IF ELSE condition is used to form the formula name that will be
186: * modified. Replace is used for replacing the SPACES woth '_' as

Line 209: hr_utility.trace('Modifying Formula ' || l_formula_name);

205: l_formula_name := upper(replace(p_new_ele_name, ' ' ,'_')) || '_TL_BALANCE_SETUP_FORMULA';
206: l_cal_formula_name := upper(replace(p_new_ele_name, ' ' ,'_')) || '_TL_FED_LEVY_CALCULATION_FORMULA';
207: end if;
208:
209: hr_utility.trace('Modifying Formula ' || l_formula_name);
210:
211: l_formula_text := NULL;
212: open c_formula_text(l_formula_name);
213: fetch c_formula_text into l_formula_text;

Line 243: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');

239: from ff_formulas_f
240: where formula_name in (l_formula_name,
241: l_cal_formula_name));
242:
243: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');
244:
245: END modify_formula_text;
246:
247: /*****************************************************************************

Line 326: -- hr_utility.trace_on(NULL, 'Dedn');

322: l_spec_feat varchar2(100);
323: l_verifier varchar2(100);
324:
325: BEGIN
326: -- hr_utility.trace_on(NULL, 'Dedn');
327: hr_utility.trace('Entering ' || gv_package_name || '.create_new_element');
328:
329: /*
330: * Initialization Code

Line 327: hr_utility.trace('Entering ' || gv_package_name || '.create_new_element');

323: l_verifier varchar2(100);
324:
325: BEGIN
326: -- hr_utility.trace_on(NULL, 'Dedn');
327: hr_utility.trace('Entering ' || gv_package_name || '.create_new_element');
328:
329: /*
330: * Initialization Code
331: */

Line 381: hr_utility.trace('Old Element ' || l_old_ele_name);

377:
378: /*
379: * Trace Statements
380: */
381: hr_utility.trace('Old Element ' || l_old_ele_name);
382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
384: hr_utility.trace('Effective End Date ' || p_eff_end_date);
385: -- hr_utility.trace_off();

Line 382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);

378: /*
379: * Trace Statements
380: */
381: hr_utility.trace('Old Element ' || l_old_ele_name);
382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
384: hr_utility.trace('Effective End Date ' || p_eff_end_date);
385: -- hr_utility.trace_off();
386:

Line 383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);

379: * Trace Statements
380: */
381: hr_utility.trace('Old Element ' || l_old_ele_name);
382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
384: hr_utility.trace('Effective End Date ' || p_eff_end_date);
385: -- hr_utility.trace_off();
386:
387: /*

Line 384: hr_utility.trace('Effective End Date ' || p_eff_end_date);

380: */
381: hr_utility.trace('Old Element ' || l_old_ele_name);
382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
384: hr_utility.trace('Effective End Date ' || p_eff_end_date);
385: -- hr_utility.trace_off();
386:
387: /*
388: * This loop tries to create a New element for the Old element

Line 385: -- hr_utility.trace_off();

381: hr_utility.trace('Old Element ' || l_old_ele_name);
382: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
383: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
384: hr_utility.trace('Effective End Date ' || p_eff_end_date);
385: -- hr_utility.trace_off();
386:
387: /*
388: * This loop tries to create a New element for the Old element
389: * A maximum of 10 elements are tried for a single OLD element.

Line 404: -- hr_utility.trace_on(NULL, 'Dedn');

400: * the one tried now.
401: */
402: l_new_elem_name := get_new_elem_name(l_old_ele_name,
403: p_business_grp_id);
404: -- hr_utility.trace_on(NULL, 'Dedn');
405: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
406: -- hr_utility.trace_off();
407:
408: /*

Line 405: hr_utility.trace('Element Name Trying ' || l_new_elem_name);

401: */
402: l_new_elem_name := get_new_elem_name(l_old_ele_name,
403: p_business_grp_id);
404: -- hr_utility.trace_on(NULL, 'Dedn');
405: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
406: -- hr_utility.trace_off();
407:
408: /*
409: * Create a Savepoint. If the element creation fails half way through

Line 406: -- hr_utility.trace_off();

402: l_new_elem_name := get_new_elem_name(l_old_ele_name,
403: p_business_grp_id);
404: -- hr_utility.trace_on(NULL, 'Dedn');
405: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
406: -- hr_utility.trace_off();
407:
408: /*
409: * Create a Savepoint. If the element creation fails half way through
410: * then we need to rollback whatever is done before trying to

Line 446: -- hr_utility.trace_on(NULL, 'Dedn');

442: ,p_srs_buy_back => l_srs_buy_back
443: );
444: exception
445: when others then
446: -- hr_utility.trace_on(NULL, 'Dedn');
447: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
448: -- hr_utility.trace_off();
449: /*
450: * Rollback to the point where the element creation was started

Line 447: hr_utility.trace('Element Name Tried ' || l_new_elem_name);

443: );
444: exception
445: when others then
446: -- hr_utility.trace_on(NULL, 'Dedn');
447: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
448: -- hr_utility.trace_off();
449: /*
450: * Rollback to the point where the element creation was started
451: */

Line 448: -- hr_utility.trace_off();

444: exception
445: when others then
446: -- hr_utility.trace_on(NULL, 'Dedn');
447: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
448: -- hr_utility.trace_off();
449: /*
450: * Rollback to the point where the element creation was started
451: */
452: rollback to ELEM_CREAT;

Line 471: -- hr_utility.trace_on(NULL, 'Dedn');

467:
468: gv_count_name := 0;
469: gv_name_not_gen.delete;
470:
471: -- hr_utility.trace_on(NULL, 'Dedn');
472: hr_utility.trace('New Element ' || l_new_elem_name);
473: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
474:
475: if l_new_ele_type_id <> 0 then

Line 472: hr_utility.trace('New Element ' || l_new_elem_name);

468: gv_count_name := 0;
469: gv_name_not_gen.delete;
470:
471: -- hr_utility.trace_on(NULL, 'Dedn');
472: hr_utility.trace('New Element ' || l_new_elem_name);
473: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
474:
475: if l_new_ele_type_id <> 0 then
476:

Line 473: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);

469: gv_name_not_gen.delete;
470:
471: -- hr_utility.trace_on(NULL, 'Dedn');
472: hr_utility.trace('New Element ' || l_new_elem_name);
473: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
474:
475: if l_new_ele_type_id <> 0 then
476:
477: hr_utility.trace('Before CALL to modify_formula_text');

Line 477: hr_utility.trace('Before CALL to modify_formula_text');

473: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
474:
475: if l_new_ele_type_id <> 0 then
476:
477: hr_utility.trace('Before CALL to modify_formula_text');
478: /*
479: * Modify The Formula text of New Base Formula
480: */
481: modify_formula_text(l_old_ele_name

Line 509: hr_utility.trace('Leaving ' || gv_package_name || '.create_new_element');

505: and business_group_id = p_business_grp_id;
506:
507: end if;
508:
509: hr_utility.trace('Leaving ' || gv_package_name || '.create_new_element');
510: return l_new_ele_type_id;
511:
512: exception
513: --

Line 516: -- hr_utility.trace_on(NULL, 'Dedn');

512: exception
513: --
514: when others then
515: l_new_ele_type_id := 0;
516: -- hr_utility.trace_on(NULL, 'Dedn');
517: hr_utility.trace('Could not create new element');
518: return l_new_ele_type_id;
519: END;
520:

Line 517: hr_utility.trace('Could not create new element');

513: --
514: when others then
515: l_new_ele_type_id := 0;
516: -- hr_utility.trace_on(NULL, 'Dedn');
517: hr_utility.trace('Could not create new element');
518: return l_new_ele_type_id;
519: END;
520:
521: /*****************************************************************************

Line 593: hr_utility.trace('Entering ' || gv_package_name || '.copy_result_rules');

589: l_formula_id number;
590: l_process_rule varchar2(10);
591:
592: BEGIN
593: hr_utility.trace('Entering ' || gv_package_name || '.copy_result_rules');
594:
595: /*
596: * Delete the formula result rules for the Old element.
597: */

Line 624: -- hr_utility.trace_off;

620: ,l_formula_id
621: ,l_process_rule;
622: close c_get_stat_proc_rules;
623:
624: -- hr_utility.trace_off;
625:
626: /*
627: * Create Processing Rule for Old Base Element. Use the Data
628: * obtained in the cursor 'c_get_stat_proc_rules'

Line 675: -- hr_utility.trace_on(NULL, 'Dedn');

671: ,p_element_type_id => l_ele_type_id);
672: end loop;
673: close c_get_form_result_rules;
674:
675: -- hr_utility.trace_on(NULL, 'Dedn');
676: hr_utility.trace('Leaving ' || gv_package_name || '.copy_result_rules');
677: END copy_result_rules;
678:
679:

Line 676: hr_utility.trace('Leaving ' || gv_package_name || '.copy_result_rules');

672: end loop;
673: close c_get_form_result_rules;
674:
675: -- hr_utility.trace_on(NULL, 'Dedn');
676: hr_utility.trace('Leaving ' || gv_package_name || '.copy_result_rules');
677: END copy_result_rules;
678:
679:
680: /*****************************************************************************

Line 748: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');

744: l_new_bal_type_id_tab number_tab;
745:
746:
747: BEGIN
748: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
749: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
750: || ' into ' || p_old_ele_name);
751: -- hr_utility.trace_off;
752:

Line 749: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name

745:
746:
747: BEGIN
748: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
749: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
750: || ' into ' || p_old_ele_name);
751: -- hr_utility.trace_off;
752:
753: /*

Line 751: -- hr_utility.trace_off;

747: BEGIN
748: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
749: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
750: || ' into ' || p_old_ele_name);
751: -- hr_utility.trace_off;
752:
753: /*
754: * Setting Location for identifying error
755: */

Line 771: hr_utility.trace('Balance Count Old Balance = ' || l_count);

767: exit when c_balance_type_id%NOTFOUND;
768: l_count := l_count + 1;
769: end loop;
770: close c_balance_type_id;
771: hr_utility.trace('Balance Count Old Balance = ' || l_count);
772:
773:
774: /*
775: * Fetching Balance Type IDs for New Balances

Line 787: hr_utility.trace('Balance Count New Balance = ' || l_count);

783: l_count := l_count + 1;
784: end loop;
785: close c_balance_type_id;
786:
787: hr_utility.trace('Balance Count New Balance = ' || l_count);
788: /*
789: * This FOR loop copies the balance feeds from New Balances
790: * to the corresponding Old Balances.
791: * The outer FOR loop runs for the New balances. For every New balance

Line 808: hr_utility.trace('Input Value ID = ' || l_inp_val_id);

804: l_inp_val_id,
805: l_scale,
806: l_leg_sub_group;
807: exit when c_input_val_id%NOTFOUND;
808: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
809: hr_utility.trace('Effective_start date ' || l_eff_start_date);
810: hr_utility.trace('Effective End Date ' || l_eff_end_date);
811:
812: /*

Line 809: hr_utility.trace('Effective_start date ' || l_eff_start_date);

805: l_scale,
806: l_leg_sub_group;
807: exit when c_input_val_id%NOTFOUND;
808: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
809: hr_utility.trace('Effective_start date ' || l_eff_start_date);
810: hr_utility.trace('Effective End Date ' || l_eff_end_date);
811:
812: /*
813: * Check If the balance feed already exists.

Line 810: hr_utility.trace('Effective End Date ' || l_eff_end_date);

806: l_leg_sub_group;
807: exit when c_input_val_id%NOTFOUND;
808: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
809: hr_utility.trace('Effective_start date ' || l_eff_start_date);
810: hr_utility.trace('Effective End Date ' || l_eff_end_date);
811:
812: /*
813: * Check If the balance feed already exists.
814: * At this point Duplicate feed cannot exist but have added the code

Line 822: hr_utility.trace('Creating Balance Feed for ' || l_old_bal_type_id_tab(l_count));

818: l_inp_val_id,
819: p_business_grp_id);
820: fetch c_chk_inp_val into l_exists;
821: if c_chk_inp_val%NOTFOUND and l_old_bal_type_id_tab.exists(l_count) then
822: hr_utility.trace('Creating Balance Feed for ' || l_old_bal_type_id_tab(l_count));
823: l_rowid := NULL;
824: l_balance_feed_id := NULL;
825:
826: pay_balance_feeds_f_pkg.Insert_Row(

Line 838: hr_utility.raise_error;

834: X_Input_Value_Id => l_inp_val_id,
835: X_Scale => l_scale,
836: X_Legislation_Subgroup => l_leg_sub_group);
837: if l_balance_feed_id is NULL then
838: hr_utility.raise_error;
839: end if;
840:
841: end if;
842: close c_chk_inp_val;

Line 847: -- hr_utility.trace_on(NULL, 'Dedn');

843: end loop;
844: close c_input_val_id;
845: end if;
846: end loop;
847: -- hr_utility.trace_on(NULL, 'Dedn');
848: hr_utility.trace('Leaving ' || gv_package_name || '.copy_balance_feeds');
849: return TRUE;
850:
851: exception

Line 848: hr_utility.trace('Leaving ' || gv_package_name || '.copy_balance_feeds');

844: close c_input_val_id;
845: end if;
846: end loop;
847: -- hr_utility.trace_on(NULL, 'Dedn');
848: hr_utility.trace('Leaving ' || gv_package_name || '.copy_balance_feeds');
849: return TRUE;
850:
851: exception
852: --

Line 854: -- hr_utility.trace_on(NULL, 'Dedn');

850:
851: exception
852: --
853: when others then
854: -- hr_utility.trace_on(NULL, 'Dedn');
855: hr_utility.trace('Could not Copy Balance Feed');
856: return FALSE;
857: END copy_balance_feeds;
858:

Line 855: hr_utility.trace('Could not Copy Balance Feed');

851: exception
852: --
853: when others then
854: -- hr_utility.trace_on(NULL, 'Dedn');
855: hr_utility.trace('Could not Copy Balance Feed');
856: return FALSE;
857: END copy_balance_feeds;
858:
859:

Line 871: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');

867: p_business_grp_id number)
868: IS
869:
870: BEGIN
871: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
872:
873: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
874: || p_new_ele_name);
875: -- hr_utility.trace_off;

Line 873: hr_utility.trace('Deleting Balance Feeds For Balances associated with '

869:
870: BEGIN
871: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
872:
873: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
874: || p_new_ele_name);
875: -- hr_utility.trace_off;
876:
877:

Line 875: -- hr_utility.trace_off;

871: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
872:
873: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
874: || p_new_ele_name);
875: -- hr_utility.trace_off;
876:
877:
878: /*
879: * This delete statement deletes the balance feeds for the balances

Line 897: -- hr_utility.trace_on(NULL, 'Dedn');

893: p_new_ele_name || ' Not Taken',
894: p_new_ele_name || ' Replacement')
895: and business_group_id = p_business_grp_id);
896:
897: -- hr_utility.trace_on(NULL, 'Dedn');
898: hr_utility.trace('Leaving ' || gv_package_name || '.del_balances');
899:
900: END del_balance_feeds;
901:

Line 898: hr_utility.trace('Leaving ' || gv_package_name || '.del_balances');

894: p_new_ele_name || ' Replacement')
895: and business_group_id = p_business_grp_id);
896:
897: -- hr_utility.trace_on(NULL, 'Dedn');
898: hr_utility.trace('Leaving ' || gv_package_name || '.del_balances');
899:
900: END del_balance_feeds;
901:
902: /*****************************************************************************

Line 948: hr_utility.trace('Entering ' || gv_package_name || '.modify_res_rule_calc');

944: l_old_fees_ele_type_id number ;
945: l_old_fees_inp_val_id number ;
946:
947: BEGIN
948: hr_utility.trace('Entering ' || gv_package_name || '.modify_res_rule_calc');
949: hr_utility.trace('Modifying The Formula ' || p_new_ele_name || ' Calculator');
950:
951:
952: /*

Line 949: hr_utility.trace('Modifying The Formula ' || p_new_ele_name || ' Calculator');

945: l_old_fees_inp_val_id number ;
946:
947: BEGIN
948: hr_utility.trace('Entering ' || gv_package_name || '.modify_res_rule_calc');
949: hr_utility.trace('Modifying The Formula ' || p_new_ele_name || ' Calculator');
950:
951:
952: /*
953: * Get the status processing rule id. This is then used in the Update

Line 973: hr_utility.trace('Modifying the STOP_ENTRY Result');

969: fetch c_get_inp_val_id_general into l_ele_type_id
970: ,l_inp_val_id;
971: close c_get_inp_val_id_general ;
972:
973: hr_utility.trace('Modifying the STOP_ENTRY Result');
974:
975: /*
976: * Updates the New Calculator formula result rule so that the
977: * STOP_ENTY result goes to the 'Pay Value' of Old Base element

Line 998: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;

994: fetch c_get_inp_val_id_general into l_old_fees_ele_type_id
995: ,l_old_fees_inp_val_id;
996: close c_get_inp_val_id_general;
997:
998: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
999: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1000: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1001:
1002: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element

Line 999: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;

995: ,l_old_fees_inp_val_id;
996: close c_get_inp_val_id_general;
997:
998: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
999: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1000: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1001:
1002: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element
1003: instead of New Fees

Line 1000: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;

996: close c_get_inp_val_id_general;
997:
998: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
999: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1000: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1001:
1002: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element
1003: instead of New Fees
1004: Using Status Processing Rule ID of New Calculator Element

Line 1014: hr_utility.trace('Leaving ' || gv_package_name || '.modify_res_rule_calc');

1010: where status_processing_rule_id = l_stat_proc_rule_id
1011: and result_name = 'WH_FEE_AMT'
1012: and business_group_id = p_business_grp_id;
1013:
1014: hr_utility.trace('Leaving ' || gv_package_name || '.modify_res_rule_calc');
1015:
1016: END modify_calc_res_rule;
1017:
1018:

Line 1041: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');

1037:
1038: l_element_type_id number;
1039:
1040: BEGIN
1041: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1042:
1043: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1044: -- hr_utility.trace_off;
1045:

Line 1043: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);

1039:
1040: BEGIN
1041: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1042:
1043: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1044: -- hr_utility.trace_off;
1045:
1046: /* Get Element Type Id */
1047:

Line 1044: -- hr_utility.trace_off;

1040: BEGIN
1041: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1042:
1043: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1044: -- hr_utility.trace_off;
1045:
1046: /* Get Element Type Id */
1047:
1048: OPEN c_element_name(p_new_ele_name);

Line 1081: -- hr_utility.trace_on(NULL, 'Dedn');

1077: FROM pay_element_types_f
1078: WHERE element_Type_id = l_element_type_id;
1079:
1080:
1081: -- hr_utility.trace_on(NULL, 'Dedn');
1082: hr_utility.trace('Leaving ' || gv_package_name || '.del_base_element');
1083:
1084: END del_base_element;
1085:

Line 1082: hr_utility.trace('Leaving ' || gv_package_name || '.del_base_element');

1078: WHERE element_Type_id = l_element_type_id;
1079:
1080:
1081: -- hr_utility.trace_on(NULL, 'Dedn');
1082: hr_utility.trace('Leaving ' || gv_package_name || '.del_base_element');
1083:
1084: END del_base_element;
1085:
1086: /*****************************************************************************

Line 1098: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');

1094: p_business_grp_id number)
1095: IS
1096:
1097: BEGIN
1098: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1099:
1100: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1101: -- hr_utility.trace_off;
1102:

Line 1100: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);

1096:
1097: BEGIN
1098: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1099:
1100: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1101: -- hr_utility.trace_off;
1102:
1103: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1104: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');

Line 1101: -- hr_utility.trace_off;

1097: BEGIN
1098: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1099:
1100: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1101: -- hr_utility.trace_off;
1102:
1103: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1104: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');
1105:

Line 1104: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');

1100: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1101: -- hr_utility.trace_off;
1102:
1103: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1104: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');
1105:
1106: /*
1107: * Update statement for elements of category 'Alimony', 'Child Support' and
1108: * 'Spousal Support'.

Line 1119: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');

1115: and business_group_id = p_business_grp_id)
1116: and pivf.name in ('Allowances')
1117: and pivf.business_group_id = p_business_grp_id;
1118: elsif p_ele_category = 'CD' or p_ele_category = 'G' then
1119: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1120:
1121: /*
1122: * Update statement for elements of category 'Credit Debt' and 'Garnishment'.
1123: */

Line 1135: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');

1131: 'Allowances',
1132: 'Clear Arrears')
1133: and pivf.business_group_id = p_business_grp_id;
1134: elsif p_ele_category = 'BO' then
1135: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1136:
1137: /*
1138: * Update statement for elements of category 'Bankruptcy Order'.
1139: */

Line 1151: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');

1147: 'Allowances',
1148: 'Clear Arrears')
1149: and pivf.business_group_id = p_business_grp_id;
1150: elsif p_ele_category = 'EL' then
1151: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1152:
1153: /*
1154: * Update statement for elements of category 'Education Loan'.
1155: */

Line 1169: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');

1165: 'Num Dependents',
1166: 'Clear Arrears')
1167: and pivf.business_group_id = p_business_grp_id;
1168: elsif p_ele_category = 'TL' then
1169: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1170:
1171: /*
1172: * Update statement for elements of category 'Tax Levy'.
1173: */

Line 1185: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');

1181: 'Num Dependents',
1182: 'Clear Arrears')
1183: and pivf.business_group_id = p_business_grp_id;
1184: elsif p_ele_category = 'ER' then
1185: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1186:
1187: /*
1188: * Update statement for elements of category 'Employee Requested'.
1189: */

Line 1202: -- hr_utility.trace_on(NULL, 'Dedn');

1198: 'Clear Arrears')
1199: and pivf.business_group_id = p_business_grp_id;
1200: end if;
1201:
1202: -- hr_utility.trace_on(NULL, 'Dedn');
1203: hr_utility.trace('Leaving ' || gv_package_name || '.mod_inp_vals');
1204:
1205: END mod_inp_vals;
1206:

Line 1203: hr_utility.trace('Leaving ' || gv_package_name || '.mod_inp_vals');

1199: and pivf.business_group_id = p_business_grp_id;
1200: end if;
1201:
1202: -- hr_utility.trace_on(NULL, 'Dedn');
1203: hr_utility.trace('Leaving ' || gv_package_name || '.mod_inp_vals');
1204:
1205: END mod_inp_vals;
1206:
1207:

Line 1276: -- hr_utility.trace_on(NULL, 'Dedn');

1272:
1273: /*
1274: * Initial Trace
1275: */
1276: -- hr_utility.trace_on(NULL, 'Dedn');
1277: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1278: hr_utility.trace('Values Passed From The Concurrent Program');
1279:
1280: /*

Line 1277: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');

1273: /*
1274: * Initial Trace
1275: */
1276: -- hr_utility.trace_on(NULL, 'Dedn');
1277: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1278: hr_utility.trace('Values Passed From The Concurrent Program');
1279:
1280: /*
1281: * Business Group Level Migration

Line 1278: hr_utility.trace('Values Passed From The Concurrent Program');

1274: * Initial Trace
1275: */
1276: -- hr_utility.trace_on(NULL, 'Dedn');
1277: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1278: hr_utility.trace('Values Passed From The Concurrent Program');
1279:
1280: /*
1281: * Business Group Level Migration
1282: */

Line 1287: hr_utility.trace('Date of Migration ' || l_date_of_mig);

1283:
1284: l_date_of_mig := fnd_date.canonical_to_date('2004/01/01');
1285: l_count := 0;
1286:
1287: hr_utility.trace('Date of Migration ' || l_date_of_mig);
1288:
1289:
1290: open c_get_mig_elem_bg(p_elem_type_id);
1291: --

Line 1312: hr_utility.trace('Element Not Created');

1308: p_business_grp_id => l_business_group_id,
1309: p_eff_start_date => l_eff_start_date,
1310: p_eff_end_date => l_eff_end_date);
1311: if l_new_ele_type_id = 0 then
1312: hr_utility.trace('Element Not Created');
1313: raise custom_exception;
1314: end if;
1315:
1316:

Line 1333: hr_utility.trace('Element Created ' || l_new_ele_name);

1329: l_business_group_id);
1330: fetch c_get_ele_name into l_old_ele_name;
1331: close c_get_ele_name;
1332:
1333: hr_utility.trace('Element Created ' || l_new_ele_name);
1334:
1335: /*
1336: * Store the New Calcualtor elements element_type_id value in the
1337: * element_information4 column of the Old Base element.

Line 1359: hr_utility.trace('Could Not Copy Balance Feed');

1355: l_flag := copy_balance_feeds(l_old_ele_name
1356: ,l_new_ele_name
1357: ,l_business_group_id);
1358: if NOT(l_flag) then
1359: hr_utility.trace('Could Not Copy Balance Feed');
1360: raise custom_exception;
1361: end if;
1362:
1363:

Line 1400: hr_utility.trace('Leaving ' || gv_package_name || '.upgrade_garnishment');

1396: end loop;
1397:
1398: close c_get_mig_elem_bg;
1399:
1400: hr_utility.trace('Leaving ' || gv_package_name || '.upgrade_garnishment');
1401: return;
1402:
1403: EXCEPTION
1404: when CUSTOM_EXCEPTION then

Line 1413: hr_utility.raise_error;

1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1410: elsif gv_location = 2 then
1411: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1412: end if;
1413: hr_utility.raise_error;
1414: when others then
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1416: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);

Line 1423: hr_utility.raise_error;

1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1420: elsif gv_location = 2 then
1421: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1422: end if;
1423: hr_utility.raise_error;
1424: end upgrade_garnishment;
1425:
1426: /*****************************************************************************
1427: Name : qual_elem_upg

Line 1487: hr_utility.trace('Entering ' || lv_package_name || '.qual_elem_upg');

1483: */
1484: l_date_of_mig := fnd_date.canonical_to_date('2004/01/01');
1485: lv_package_name := 'pay_us_garn_upgrade';
1486:
1487: hr_utility.trace('Entering ' || lv_package_name || '.qual_elem_upg');
1488:
1489:
1490: /*
1491: * Check current architecture.

Line 1522: hr_utility.trace('Element Type ID ' || p_object_id || 'Upgraded');

1518:
1519: p_qualified := l_qualifier;
1520:
1521: if l_qualifier = 'Y' then
1522: hr_utility.trace('Element Type ID ' || p_object_id || 'Upgraded');
1523: end if;
1524: hr_utility.trace('Leaving ' || lv_package_name || '.qual_elem_upg');
1525: END qual_elem_upg;
1526:

Line 1524: hr_utility.trace('Leaving ' || lv_package_name || '.qual_elem_upg');

1520:
1521: if l_qualifier = 'Y' then
1522: hr_utility.trace('Element Type ID ' || p_object_id || 'Upgraded');
1523: end if;
1524: hr_utility.trace('Leaving ' || lv_package_name || '.qual_elem_upg');
1525: END qual_elem_upg;
1526:
1527: end pay_us_garn_upgrade;