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

APPS.PAY_US_GARN_UPGRADE dependencies on HR_UTILITY

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

185: l_cal_formula_name varchar2(100);
186: l_formula_text ff_formulas_f.formula_text%TYPE;
187: l_new_formula_text ff_formulas_f.formula_text%TYPE;
188: BEGIN
189: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
190:
191: /*
192: * IF ELSE condition is used to form the formula name that will be
193: * modified. Replace is used for replacing the SPACES woth '_' as

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

212: l_formula_name := upper(replace(p_new_ele_name, ' ' ,'_')) || '_TL_BALANCE_SETUP_FORMULA';
213: l_cal_formula_name := upper(replace(p_new_ele_name, ' ' ,'_')) || '_TL_FED_LEVY_CALCULATION_FORMULA';
214: end if;
215:
216: hr_utility.trace('Modifying Formula ' || l_formula_name);
217:
218: l_formula_text := NULL;
219: open c_formula_text(l_formula_name);
220: fetch c_formula_text into l_formula_text;

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

246: from ff_formulas_f
247: where formula_name in (l_formula_name,
248: l_cal_formula_name));
249:
250: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');
251:
252: END modify_formula_text;
253:
254: /*****************************************************************************

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

329: l_spec_feat varchar2(100);
330: l_verifier varchar2(100);
331:
332: BEGIN
333: -- hr_utility.trace_on(NULL, 'Dedn');
334: hr_utility.trace('Entering ' || gv_package_name || '.create_new_element');
335:
336: /*
337: * Initialization Code

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

330: l_verifier varchar2(100);
331:
332: BEGIN
333: -- hr_utility.trace_on(NULL, 'Dedn');
334: hr_utility.trace('Entering ' || gv_package_name || '.create_new_element');
335:
336: /*
337: * Initialization Code
338: */

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

384:
385: /*
386: * Trace Statements
387: */
388: hr_utility.trace('Old Element ' || l_old_ele_name);
389: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
390: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
391: hr_utility.trace('Effective End Date ' || p_eff_end_date);
392: -- hr_utility.trace_off();

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

385: /*
386: * Trace Statements
387: */
388: hr_utility.trace('Old Element ' || l_old_ele_name);
389: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
390: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
391: hr_utility.trace('Effective End Date ' || p_eff_end_date);
392: -- hr_utility.trace_off();
393:

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

386: * Trace Statements
387: */
388: hr_utility.trace('Old Element ' || l_old_ele_name);
389: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
390: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
391: hr_utility.trace('Effective End Date ' || p_eff_end_date);
392: -- hr_utility.trace_off();
393:
394: /*

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

387: */
388: hr_utility.trace('Old Element ' || l_old_ele_name);
389: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
390: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
391: hr_utility.trace('Effective End Date ' || p_eff_end_date);
392: -- hr_utility.trace_off();
393:
394: /*
395: * This loop tries to create a New element for the Old element

Line 392: -- hr_utility.trace_off();

388: hr_utility.trace('Old Element ' || l_old_ele_name);
389: hr_utility.trace('Old Element Type ID ' || p_old_ele_type_id);
390: hr_utility.trace('Effective Start Date ' || p_eff_start_date);
391: hr_utility.trace('Effective End Date ' || p_eff_end_date);
392: -- hr_utility.trace_off();
393:
394: /*
395: * This loop tries to create a New element for the Old element
396: * A maximum of 10 elements are tried for a single OLD element.

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

407: * the one tried now.
408: */
409: l_new_elem_name := get_new_elem_name(l_old_ele_name,
410: p_business_grp_id);
411: -- hr_utility.trace_on(NULL, 'Dedn');
412: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
413: -- hr_utility.trace_off();
414:
415: /*

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

408: */
409: l_new_elem_name := get_new_elem_name(l_old_ele_name,
410: p_business_grp_id);
411: -- hr_utility.trace_on(NULL, 'Dedn');
412: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
413: -- hr_utility.trace_off();
414:
415: /*
416: * Create a Savepoint. If the element creation fails half way through

Line 413: -- hr_utility.trace_off();

409: l_new_elem_name := get_new_elem_name(l_old_ele_name,
410: p_business_grp_id);
411: -- hr_utility.trace_on(NULL, 'Dedn');
412: hr_utility.trace('Element Name Trying ' || l_new_elem_name);
413: -- hr_utility.trace_off();
414:
415: /*
416: * Create a Savepoint. If the element creation fails half way through
417: * then we need to rollback whatever is done before trying to

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

449: ,p_srs_buy_back => l_srs_buy_back
450: );
451: exception
452: when others then
453: -- hr_utility.trace_on(NULL, 'Dedn');
454: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
455: -- hr_utility.trace_off();
456: /*
457: * Rollback to the point where the element creation was started

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

450: );
451: exception
452: when others then
453: -- hr_utility.trace_on(NULL, 'Dedn');
454: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
455: -- hr_utility.trace_off();
456: /*
457: * Rollback to the point where the element creation was started
458: */

Line 455: -- hr_utility.trace_off();

451: exception
452: when others then
453: -- hr_utility.trace_on(NULL, 'Dedn');
454: hr_utility.trace('Element Name Tried ' || l_new_elem_name);
455: -- hr_utility.trace_off();
456: /*
457: * Rollback to the point where the element creation was started
458: */
459: rollback to ELEM_CREAT;

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

474:
475: gv_count_name := 0;
476: gv_name_not_gen.delete;
477:
478: -- hr_utility.trace_on(NULL, 'Dedn');
479: hr_utility.trace('New Element ' || l_new_elem_name);
480: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
481:
482: if l_new_ele_type_id <> 0 then

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

475: gv_count_name := 0;
476: gv_name_not_gen.delete;
477:
478: -- hr_utility.trace_on(NULL, 'Dedn');
479: hr_utility.trace('New Element ' || l_new_elem_name);
480: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
481:
482: if l_new_ele_type_id <> 0 then
483:

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

476: gv_name_not_gen.delete;
477:
478: -- hr_utility.trace_on(NULL, 'Dedn');
479: hr_utility.trace('New Element ' || l_new_elem_name);
480: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
481:
482: if l_new_ele_type_id <> 0 then
483:
484: hr_utility.trace('Before CALL to modify_formula_text');

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

480: hr_utility.trace('New Element Type ID ' || l_new_ele_type_id);
481:
482: if l_new_ele_type_id <> 0 then
483:
484: hr_utility.trace('Before CALL to modify_formula_text');
485: /*
486: * Modify The Formula text of New Base Formula
487: */
488: modify_formula_text(l_old_ele_name

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

512: and business_group_id = p_business_grp_id;
513:
514: end if;
515:
516: hr_utility.trace('Leaving ' || gv_package_name || '.create_new_element');
517: return l_new_ele_type_id;
518:
519: exception
520: --

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

519: exception
520: --
521: when others then
522: l_new_ele_type_id := 0;
523: -- hr_utility.trace_on(NULL, 'Dedn');
524: hr_utility.trace('Could not create new element');
525: return l_new_ele_type_id;
526: END;
527:

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

520: --
521: when others then
522: l_new_ele_type_id := 0;
523: -- hr_utility.trace_on(NULL, 'Dedn');
524: hr_utility.trace('Could not create new element');
525: return l_new_ele_type_id;
526: END;
527:
528: /*****************************************************************************

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

596: l_formula_id number;
597: l_process_rule varchar2(10);
598:
599: BEGIN
600: hr_utility.trace('Entering ' || gv_package_name || '.copy_result_rules');
601:
602: /*
603: * Delete the formula result rules for the Old element.
604: */

Line 631: -- hr_utility.trace_off;

627: ,l_formula_id
628: ,l_process_rule;
629: close c_get_stat_proc_rules;
630:
631: -- hr_utility.trace_off;
632:
633: /*
634: * Create Processing Rule for Old Base Element. Use the Data
635: * obtained in the cursor 'c_get_stat_proc_rules'

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

678: ,p_element_type_id => l_ele_type_id);
679: end loop;
680: close c_get_form_result_rules;
681:
682: -- hr_utility.trace_on(NULL, 'Dedn');
683: hr_utility.trace('Leaving ' || gv_package_name || '.copy_result_rules');
684: END copy_result_rules;
685:
686:

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

679: end loop;
680: close c_get_form_result_rules;
681:
682: -- hr_utility.trace_on(NULL, 'Dedn');
683: hr_utility.trace('Leaving ' || gv_package_name || '.copy_result_rules');
684: END copy_result_rules;
685:
686:
687: /*****************************************************************************

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

751: l_new_bal_type_id_tab number_tab;
752:
753:
754: BEGIN
755: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
756: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
757: || ' into ' || p_old_ele_name);
758: -- hr_utility.trace_off;
759:

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

752:
753:
754: BEGIN
755: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
756: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
757: || ' into ' || p_old_ele_name);
758: -- hr_utility.trace_off;
759:
760: /*

Line 758: -- hr_utility.trace_off;

754: BEGIN
755: hr_utility.trace('Entering ' || gv_package_name || '.copy_balance_feeds');
756: hr_utility.trace('Copying Balance Feeds from ' || p_new_ele_name
757: || ' into ' || p_old_ele_name);
758: -- hr_utility.trace_off;
759:
760: /*
761: * Setting Location for identifying error
762: */

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

774: exit when c_balance_type_id%NOTFOUND;
775: l_count := l_count + 1;
776: end loop;
777: close c_balance_type_id;
778: hr_utility.trace('Balance Count Old Balance = ' || l_count);
779:
780:
781: /*
782: * Fetching Balance Type IDs for New Balances

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

790: l_count := l_count + 1;
791: end loop;
792: close c_balance_type_id;
793:
794: hr_utility.trace('Balance Count New Balance = ' || l_count);
795: /*
796: * This FOR loop copies the balance feeds from New Balances
797: * to the corresponding Old Balances.
798: * The outer FOR loop runs for the New balances. For every New balance

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

811: l_inp_val_id,
812: l_scale,
813: l_leg_sub_group;
814: exit when c_input_val_id%NOTFOUND;
815: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
816: hr_utility.trace('Effective_start date ' || l_eff_start_date);
817: hr_utility.trace('Effective End Date ' || l_eff_end_date);
818:
819: /*

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

812: l_scale,
813: l_leg_sub_group;
814: exit when c_input_val_id%NOTFOUND;
815: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
816: hr_utility.trace('Effective_start date ' || l_eff_start_date);
817: hr_utility.trace('Effective End Date ' || l_eff_end_date);
818:
819: /*
820: * Check If the balance feed already exists.

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

813: l_leg_sub_group;
814: exit when c_input_val_id%NOTFOUND;
815: hr_utility.trace('Input Value ID = ' || l_inp_val_id);
816: hr_utility.trace('Effective_start date ' || l_eff_start_date);
817: hr_utility.trace('Effective End Date ' || l_eff_end_date);
818:
819: /*
820: * Check If the balance feed already exists.
821: * At this point Duplicate feed cannot exist but have added the code

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

825: l_inp_val_id,
826: p_business_grp_id);
827: fetch c_chk_inp_val into l_exists;
828: if c_chk_inp_val%NOTFOUND and l_old_bal_type_id_tab.exists(l_count) then
829: hr_utility.trace('Creating Balance Feed for ' || l_old_bal_type_id_tab(l_count));
830: l_rowid := NULL;
831: l_balance_feed_id := NULL;
832:
833: pay_balance_feeds_f_pkg.Insert_Row(

Line 845: hr_utility.raise_error;

841: X_Input_Value_Id => l_inp_val_id,
842: X_Scale => l_scale,
843: X_Legislation_Subgroup => l_leg_sub_group);
844: if l_balance_feed_id is NULL then
845: hr_utility.raise_error;
846: end if;
847:
848: end if;
849: close c_chk_inp_val;

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

850: end loop;
851: close c_input_val_id;
852: end if;
853: end loop;
854: -- hr_utility.trace_on(NULL, 'Dedn');
855: hr_utility.trace('Leaving ' || gv_package_name || '.copy_balance_feeds');
856: return TRUE;
857:
858: exception

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

851: close c_input_val_id;
852: end if;
853: end loop;
854: -- hr_utility.trace_on(NULL, 'Dedn');
855: hr_utility.trace('Leaving ' || gv_package_name || '.copy_balance_feeds');
856: return TRUE;
857:
858: exception
859: --

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

857:
858: exception
859: --
860: when others then
861: -- hr_utility.trace_on(NULL, 'Dedn');
862: hr_utility.trace('Could not Copy Balance Feed');
863: return FALSE;
864: END copy_balance_feeds;
865:

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

858: exception
859: --
860: when others then
861: -- hr_utility.trace_on(NULL, 'Dedn');
862: hr_utility.trace('Could not Copy Balance Feed');
863: return FALSE;
864: END copy_balance_feeds;
865:
866:

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

874: p_business_grp_id number)
875: IS
876:
877: BEGIN
878: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
879:
880: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
881: || p_new_ele_name);
882: -- hr_utility.trace_off;

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

876:
877: BEGIN
878: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
879:
880: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
881: || p_new_ele_name);
882: -- hr_utility.trace_off;
883:
884:

Line 882: -- hr_utility.trace_off;

878: hr_utility.trace('Entering ' || gv_package_name || '.del_balances');
879:
880: hr_utility.trace('Deleting Balance Feeds For Balances associated with '
881: || p_new_ele_name);
882: -- hr_utility.trace_off;
883:
884:
885: /*
886: * This delete statement deletes the balance feeds for the balances

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

900: p_new_ele_name || ' Not Taken',
901: p_new_ele_name || ' Replacement')
902: and business_group_id = p_business_grp_id);
903:
904: -- hr_utility.trace_on(NULL, 'Dedn');
905: hr_utility.trace('Leaving ' || gv_package_name || '.del_balances');
906:
907: END del_balance_feeds;
908:

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

901: p_new_ele_name || ' Replacement')
902: and business_group_id = p_business_grp_id);
903:
904: -- hr_utility.trace_on(NULL, 'Dedn');
905: hr_utility.trace('Leaving ' || gv_package_name || '.del_balances');
906:
907: END del_balance_feeds;
908:
909: /*****************************************************************************

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

951: l_old_fees_ele_type_id number ;
952: l_old_fees_inp_val_id number ;
953:
954: BEGIN
955: hr_utility.trace('Entering ' || gv_package_name || '.modify_res_rule_calc');
956: hr_utility.trace('Modifying The Formula ' || p_new_ele_name || ' Calculator');
957:
958:
959: /*

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

952: l_old_fees_inp_val_id number ;
953:
954: BEGIN
955: hr_utility.trace('Entering ' || gv_package_name || '.modify_res_rule_calc');
956: hr_utility.trace('Modifying The Formula ' || p_new_ele_name || ' Calculator');
957:
958:
959: /*
960: * Get the status processing rule id. This is then used in the Update

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

976: fetch c_get_inp_val_id_general into l_ele_type_id
977: ,l_inp_val_id;
978: close c_get_inp_val_id_general ;
979:
980: hr_utility.trace('Modifying the STOP_ENTRY Result');
981:
982: /*
983: * Updates the New Calculator formula result rule so that the
984: * STOP_ENTY result goes to the 'Pay Value' of Old Base element

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

1001: fetch c_get_inp_val_id_general into l_old_fees_ele_type_id
1002: ,l_old_fees_inp_val_id;
1003: close c_get_inp_val_id_general;
1004:
1005: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
1006: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1007: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1008:
1009: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element

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

1002: ,l_old_fees_inp_val_id;
1003: close c_get_inp_val_id_general;
1004:
1005: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
1006: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1007: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1008:
1009: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element
1010: instead of New Fees

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

1003: close c_get_inp_val_id_general;
1004:
1005: hr_utility.trace('Ele Typ ID for Old Fees Ele := '||l_old_fees_ele_type_id) ;
1006: hr_utility.trace('Inp Val ID for Withheld Fee Amt for Old Fees Ele := '||l_old_fees_inp_val_id) ;
1007: hr_utility.trace('Status Proc Rule ID = '||l_stat_proc_rule_id) ;
1008:
1009: /* Updating FRR so that WH_FEE_AMT feeds Withheld Fee Amount of Old Fees Element
1010: instead of New Fees
1011: Using Status Processing Rule ID of New Calculator Element

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

1017: where status_processing_rule_id = l_stat_proc_rule_id
1018: and result_name = 'WH_FEE_AMT'
1019: and business_group_id = p_business_grp_id;
1020:
1021: hr_utility.trace('Leaving ' || gv_package_name || '.modify_res_rule_calc');
1022:
1023: END modify_calc_res_rule;
1024:
1025:

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

1044:
1045: l_element_type_id number;
1046:
1047: BEGIN
1048: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1049:
1050: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1051: -- hr_utility.trace_off;
1052:

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

1046:
1047: BEGIN
1048: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1049:
1050: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1051: -- hr_utility.trace_off;
1052:
1053: /* Get Element Type Id */
1054:

Line 1051: -- hr_utility.trace_off;

1047: BEGIN
1048: hr_utility.trace('Entering ' || gv_package_name || '.del_base_element');
1049:
1050: hr_utility.trace('Deleting Base Element ' || p_new_ele_name);
1051: -- hr_utility.trace_off;
1052:
1053: /* Get Element Type Id */
1054:
1055: OPEN c_element_name(p_new_ele_name);

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

1084: FROM pay_element_types_f
1085: WHERE element_Type_id = l_element_type_id;
1086:
1087:
1088: -- hr_utility.trace_on(NULL, 'Dedn');
1089: hr_utility.trace('Leaving ' || gv_package_name || '.del_base_element');
1090:
1091: END del_base_element;
1092:

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

1085: WHERE element_Type_id = l_element_type_id;
1086:
1087:
1088: -- hr_utility.trace_on(NULL, 'Dedn');
1089: hr_utility.trace('Leaving ' || gv_package_name || '.del_base_element');
1090:
1091: END del_base_element;
1092:
1093: /*****************************************************************************

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

1101: p_business_grp_id number)
1102: IS
1103:
1104: BEGIN
1105: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1106:
1107: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1108: -- hr_utility.trace_off;
1109:

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

1103:
1104: BEGIN
1105: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1106:
1107: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1108: -- hr_utility.trace_off;
1109:
1110: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1111: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');

Line 1108: -- hr_utility.trace_off;

1104: BEGIN
1105: hr_utility.trace('Entering ' || gv_package_name || '.mod_inp_vals');
1106:
1107: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1108: -- hr_utility.trace_off;
1109:
1110: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1111: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');
1112:

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

1107: hr_utility.trace('Modifying the Display Sequence for the element ' || p_ele_name);
1108: -- hr_utility.trace_off;
1109:
1110: if p_ele_category = 'AY' OR p_ele_category = 'CS' or p_ele_category = 'SS' then
1111: hr_utility.trace('Setting Mandatory Flag for the Input Value Allowances');
1112:
1113: /*
1114: * Update statement for elements of category 'Alimony', 'Child Support' and
1115: * 'Spousal Support'.

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

1122: and business_group_id = p_business_grp_id)
1123: and pivf.name in ('Allowances')
1124: and pivf.business_group_id = p_business_grp_id;
1125: elsif p_ele_category = 'CD' or p_ele_category = 'G' then
1126: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1127:
1128: /*
1129: * Update statement for elements of category 'Credit Debt' and 'Garnishment'.
1130: */

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

1138: 'Allowances',
1139: 'Clear Arrears')
1140: and pivf.business_group_id = p_business_grp_id;
1141: elsif p_ele_category = 'BO' then
1142: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1143:
1144: /*
1145: * Update statement for elements of category 'Bankruptcy Order'.
1146: */

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

1154: 'Allowances',
1155: 'Clear Arrears')
1156: and pivf.business_group_id = p_business_grp_id;
1157: elsif p_ele_category = 'EL' then
1158: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1159:
1160: /*
1161: * Update statement for elements of category 'Education Loan'.
1162: */

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

1172: 'Num Dependents',
1173: 'Clear Arrears')
1174: and pivf.business_group_id = p_business_grp_id;
1175: elsif p_ele_category = 'TL' then
1176: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1177:
1178: /*
1179: * Update statement for elements of category 'Tax Levy'.
1180: */

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

1188: 'Num Dependents',
1189: 'Clear Arrears')
1190: and pivf.business_group_id = p_business_grp_id;
1191: elsif p_ele_category = 'ER' then
1192: hr_utility.trace('Setting Mandatory Flag for the Input Value Dedns at Time of Writ, Allowances and Clear Arrears.');
1193:
1194: /*
1195: * Update statement for elements of category 'Employee Requested'.
1196: */

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

1205: 'Clear Arrears')
1206: and pivf.business_group_id = p_business_grp_id;
1207: end if;
1208:
1209: -- hr_utility.trace_on(NULL, 'Dedn');
1210: hr_utility.trace('Leaving ' || gv_package_name || '.mod_inp_vals');
1211:
1212: END mod_inp_vals;
1213:

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

1206: and pivf.business_group_id = p_business_grp_id;
1207: end if;
1208:
1209: -- hr_utility.trace_on(NULL, 'Dedn');
1210: hr_utility.trace('Leaving ' || gv_package_name || '.mod_inp_vals');
1211:
1212: END mod_inp_vals;
1213:
1214:

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

1281:
1282: /*
1283: * Initial Trace
1284: */
1285: -- hr_utility.trace_on(NULL, 'Dedn');
1286: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1287: hr_utility.trace('Values Passed From The Concurrent Program');
1288:
1289: /*

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

1282: /*
1283: * Initial Trace
1284: */
1285: -- hr_utility.trace_on(NULL, 'Dedn');
1286: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1287: hr_utility.trace('Values Passed From The Concurrent Program');
1288:
1289: /*
1290: * Business Group Level Migration

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

1283: * Initial Trace
1284: */
1285: -- hr_utility.trace_on(NULL, 'Dedn');
1286: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_garnishment');
1287: hr_utility.trace('Values Passed From The Concurrent Program');
1288:
1289: /*
1290: * Business Group Level Migration
1291: */

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

1292:
1293: l_date_of_mig := fnd_date.canonical_to_date('2004/01/01');
1294: l_count := 0;
1295:
1296: hr_utility.trace('Date of Migration ' || l_date_of_mig);
1297:
1298:
1299: open c_get_mig_elem_bg(p_elem_type_id);
1300: --

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

1317: p_business_grp_id => l_business_group_id,
1318: p_eff_start_date => l_eff_start_date,
1319: p_eff_end_date => l_eff_end_date);
1320: if l_new_ele_type_id = 0 then
1321: hr_utility.trace('Element Not Created');
1322: raise custom_exception;
1323: end if;
1324:
1325:

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

1339: l_business_group_id);
1340: fetch c_get_ele_name into l_old_ele_name;
1341: close c_get_ele_name;
1342:
1343: hr_utility.trace('Element Created ' || l_new_ele_name);
1344:
1345: /*
1346: * Store the New Calcualtor elements element_type_id value in the
1347: * element_information4 column of the Old Base element.

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

1370: l_flag := copy_balance_feeds(l_old_ele_name
1371: ,l_new_ele_name
1372: ,l_business_group_id);
1373: if NOT(l_flag) then
1374: hr_utility.trace('Could Not Copy Balance Feed');
1375: raise custom_exception;
1376: end if;
1377:
1378:

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

1411: end loop;
1412:
1413: close c_get_mig_elem_bg;
1414:
1415: hr_utility.trace('Leaving ' || gv_package_name || '.upgrade_garnishment');
1416: return;
1417:
1418: EXCEPTION
1419: when CUSTOM_EXCEPTION then

Line 1428: hr_utility.raise_error;

1424: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1425: elsif gv_location = 2 then
1426: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1427: end if;
1428: hr_utility.raise_error;
1429: when others then
1430: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1431: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1432: pay_core_utils.push_token ('Element Name ', l_old_ele_name);

Line 1438: hr_utility.raise_error;

1434: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1435: elsif gv_location = 2 then
1436: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1437: end if;
1438: hr_utility.raise_error;
1439: end upgrade_garnishment;
1440:
1441: /*****************************************************************************
1442: Name : qual_elem_upg

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

1498: */
1499: l_date_of_mig := fnd_date.canonical_to_date('2004/01/01');
1500: lv_package_name := 'pay_us_garn_upgrade';
1501:
1502: hr_utility.trace('Entering ' || lv_package_name || '.qual_elem_upg');
1503:
1504:
1505: /*
1506: * Check current architecture.

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

1533:
1534: p_qualified := l_qualifier;
1535:
1536: if l_qualifier = 'Y' then
1537: hr_utility.trace('Element Type ID ' || p_object_id || 'Upgraded');
1538: end if;
1539: hr_utility.trace('Leaving ' || lv_package_name || '.qual_elem_upg');
1540: END qual_elem_upg;
1541:

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

1535:
1536: if l_qualifier = 'Y' then
1537: hr_utility.trace('Element Type ID ' || p_object_id || 'Upgraded');
1538: end if;
1539: hr_utility.trace('Leaving ' || lv_package_name || '.qual_elem_upg');
1540: END qual_elem_upg;
1541:
1542: end pay_us_garn_upgrade;