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

Line 174: hr_utility.trace('l_classification_name = ' || l_classification_name(i));

170: END IF;
171:
172: FOR i IN l_classification_name.FIRST .. l_classification_name.LAST LOOP
173:
174: hr_utility.trace('l_classification_name = ' || l_classification_name(i));
175: l_classification_id := get_classification_id(l_classification_name(i),p_legislation_code);
176:
177: SELECT COUNT(*)
178: INTO ln_exists

Line 183: hr_utility.trace('ln_exists = ' || to_char(ln_exists));

179: FROM pay_ele_tmplt_class_usages
180: WHERE classification_id = l_classification_id
181: AND template_id = p_template_id;
182:
183: hr_utility.trace('ln_exists = ' || to_char(ln_exists));
184:
185: IF ln_exists = 0 THEN
186:
187: SELECT pay_ele_tmplt_class_usg_s.nextval

Line 191: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);

187: SELECT pay_ele_tmplt_class_usg_s.nextval
188: INTO ln_ele_tmplt_class_id
189: FROM dual;
190:
191: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
192:
193: INSERT INTO pay_ele_tmplt_class_usages
194: ( ele_template_classification_id
195: ,classification_id

Line 269: --hr_utility.trace_on (null,'FLATAMTDEDN');

265:
266:
267: begin
268:
269: --hr_utility.trace_on (null,'FLATAMTDEDN');
270:
271:
272: /* Check for Template Existence */
273:

Line 613: hr_utility.trace('Base Element Created');

609: ,p_effective_date => l_effective_date
610: ,p_exclusion_rule_id => NULL
611: );
612:
613: hr_utility.trace('Base Element Created');
614:
615: --
616: -- 'Special Features' element.
617: --

Line 642: hr_utility.trace('Special Features Element Created');

638: ,p_object_version_number => l_object_version_number
639: ,p_effective_date => l_effective_date
640: );
641:
642: hr_utility.trace('Special Features Element Created');
643:
644: --
645: -- Input Values for 'Base' element.
646: --

Line 662: hr_utility.trace('Base Element Input Value - Pay Value Created');

658: ,p_object_version_number => l_object_version_number
659: ,p_effective_date => l_effective_date
660: );
661:
662: hr_utility.trace('Base Element Input Value - Pay Value Created');
663:
664: pay_siv_ins.ins
665: (p_input_value_id => l_base_amount_id
666: ,p_element_type_id => l_base_element_id

Line 678: hr_utility.trace('Base Element Input Value - Amount Created');

674: ,p_object_version_number => l_object_version_number
675: ,p_effective_date => l_effective_date
676: );
677:
678: hr_utility.trace('Base Element Input Value - Amount Created');
679:
680: pay_siv_ins.ins
681: (p_input_value_id => l_clear_arr_iv_id
682: ,p_element_type_id => l_base_element_id

Line 696: hr_utility.trace('Base Element Input Value - Clear Arrears Created');

692: ,p_exclusion_rule_id => l_arrearage_rule_id
693: ,p_effective_date => l_effective_date
694: );
695:
696: hr_utility.trace('Base Element Input Value - Clear Arrears Created');
697:
698: pay_siv_ins.ins
699: (p_input_value_id => l_total_owed_iv_id
700: ,p_element_type_id => l_base_element_id

Line 712: hr_utility.trace('Base Element Input Value - Total Owed Created');

708: ,p_exclusion_rule_id => l_stop_rule_id
709: ,p_effective_date => l_effective_date
710: );
711:
712: hr_utility.trace('Base Element Input Value - Total Owed Created');
713:
714:
715: --
716: -- Input Values for 'Special Features' element.

Line 732: hr_utility.trace('Pay Value for Special Features Created');

728: ,p_object_version_number => l_object_version_number
729: ,p_effective_date => l_effective_date
730: );
731:
732: hr_utility.trace('Pay Value for Special Features Created');
733:
734: pay_siv_ins.ins
735: (p_input_value_id => l_sf_accrued_value_id
736: ,p_element_type_id => l_special_features_element_id

Line 748: hr_utility.trace('Accrued Input Value for Special Features Created');

744: ,p_exclusion_rule_id => l_stop_rule_id
745: ,p_effective_date => l_effective_date
746: );
747:
748: hr_utility.trace('Accrued Input Value for Special Features Created');
749:
750: pay_siv_ins.ins
751: (p_input_value_id => l_sf_not_taken_value_id
752: ,p_element_type_id => l_special_features_element_id

Line 763: hr_utility.trace('Not Taken Input Value for Special Features Created');

759: ,p_object_version_number => l_object_version_number
760: ,p_effective_date => l_effective_date
761: );
762:
763: hr_utility.trace('Not Taken Input Value for Special Features Created');
764:
765: pay_siv_ins.ins
766: (p_input_value_id => l_sf_arrears_contr_value_id
767: ,p_element_type_id => l_special_features_element_id

Line 779: hr_utility.trace('Arrears Contr Input Value for Spec Features Created');

775: ,p_exclusion_rule_id => l_arrearage_rule_id
776: ,p_effective_date => l_effective_date
777: );
778:
779: hr_utility.trace('Arrears Contr Input Value for Spec Features Created');
780:
781: --
782: -- Primary balance types.
783: --

Line 801: hr_utility.trace('Primary Balance Type Created.');

797: ,p_object_version_number => l_object_version_number
798: ,p_effective_date => l_effective_date
799: );
800:
801: hr_utility.trace('Primary Balance Type Created.');
802:
803: pay_sbt_ins.ins
804: (p_balance_type_id => l_accrued_bal_typ_id
805: ,p_template_id => l_template_id

Line 820: hr_utility.trace('Accrued Balance Type Created.');

816: ,p_effective_date => l_effective_date
817: );
818:
819:
820: hr_utility.trace('Accrued Balance Type Created.');
821:
822: pay_sbt_ins.ins
823: (p_balance_type_id => l_arrears_bal_typ_id
824: ,p_template_id => l_template_id

Line 838: hr_utility.trace('Arrears Balance Type Created.');

834: ,p_object_version_number => l_object_version_number
835: ,p_effective_date => l_effective_date
836: );
837:
838: hr_utility.trace('Arrears Balance Type Created.');
839:
840: pay_sbt_ins.ins
841: (p_balance_type_id => l_not_taken_bal_typ_id
842: ,p_template_id => l_template_id

Line 856: hr_utility.trace('Not Taken Balance Type Created.');

852: ,p_object_version_number => l_object_version_number
853: ,p_effective_date => l_effective_date
854: );
855:
856: hr_utility.trace('Not Taken Balance Type Created.');
857:
858: --
859: -- Balance Feeds.
860: --

Line 871: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');

867: ,p_object_version_number => l_object_version_number
868: ,p_effective_date => l_effective_date
869: );
870:
871: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');
872:
873: pay_sbf_ins.ins
874: (p_balance_feed_id => l_balance_feed_id
875: ,p_balance_type_id => l_accrued_bal_typ_id

Line 882: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');

878: ,p_object_version_number => l_object_version_number
879: ,p_effective_date => l_effective_date
880: );
881:
882: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');
883:
884: pay_sbf_ins.ins
885: (p_balance_feed_id => l_balance_feed_id
886: ,p_balance_type_id => l_not_taken_bal_typ_id

Line 894: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');

890: ,p_object_version_number => l_object_version_number
891: ,p_effective_date => l_effective_date
892: );
893:
894: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');
895:
896: pay_sbf_ins.ins
897: (p_balance_feed_id => l_balance_feed_id
898: ,p_balance_type_id => l_arrears_bal_typ_id

Line 906: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');

902: ,p_object_version_number => l_object_version_number
903: ,p_effective_date => l_effective_date
904: );
905:
906: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');
907:
908: --
909: -- Formula rules.
910: --

Line 923: hr_utility.trace('Formula Rule - dedn_amt created.');

919: ,p_object_version_number => l_object_version_number
920: ,p_effective_date => l_effective_date
921: );
922:
923: hr_utility.trace('Formula Rule - dedn_amt created.');
924:
925: pay_sfr_ins.ins
926: (p_formula_result_rule_id => l_id
927: ,p_shadow_element_type_id => l_base_element_id

Line 936: hr_utility.trace('Formula Rule - STOP_ENTRY created.');

932: ,p_object_version_number => l_object_version_number
933: ,p_effective_date => l_effective_date
934: );
935:
936: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
937:
938: pay_sfr_ins.ins
939: (p_formula_result_rule_id => l_id
940: ,p_shadow_element_type_id => l_base_element_id

Line 950: hr_utility.trace('Formula Rule - set_clear created.');

946: ,p_object_version_number => l_object_version_number
947: ,p_effective_date => l_effective_date
948: );
949:
950: hr_utility.trace('Formula Rule - set_clear created.');
951:
952: pay_sfr_ins.ins
953: (p_formula_result_rule_id => l_id
954: ,p_shadow_element_type_id => l_base_element_id

Line 962: hr_utility.trace('Formula Rule - mesg created.');

958: ,p_object_version_number => l_object_version_number
959: ,p_effective_date => l_effective_date
960: );
961:
962: hr_utility.trace('Formula Rule - mesg created.');
963:
964: pay_sfr_ins.ins
965: (p_formula_result_rule_id => l_id
966: ,p_shadow_element_type_id => l_base_element_id

Line 975: hr_utility.trace('Formula Rule - to_not_taken created.');

971: ,p_object_version_number => l_object_version_number
972: ,p_effective_date => l_effective_date
973: );
974:
975: hr_utility.trace('Formula Rule - to_not_taken created.');
976:
977: pay_sfr_ins.ins
978: (p_formula_result_rule_id => l_id
979: ,p_shadow_element_type_id => l_base_element_id

Line 989: hr_utility.trace('Formula Rule - to_total_owed created.');

985: ,p_object_version_number => l_object_version_number
986: ,p_effective_date => l_effective_date
987: );
988:
989: hr_utility.trace('Formula Rule - to_total_owed created.');
990:
991: pay_sfr_ins.ins
992: (p_formula_result_rule_id => l_id
993: ,p_shadow_element_type_id => l_base_element_id

Line 1003: hr_utility.trace('Formula Rule - to_arrears created.');

999: ,p_object_version_number => l_object_version_number
1000: ,p_effective_date => l_effective_date
1001: );
1002:
1003: hr_utility.trace('Formula Rule - to_arrears created.');
1004:
1005: --
1006: -- Defined Balances for Base Balance
1007: --

Line 1406: --hr_utility.trace_on (null,'FLATAMT');

1402:
1403:
1404: begin
1405:
1406: --hr_utility.trace_on (null,'FLATAMT');
1407:
1408:
1409: /* Check for Template Existence */
1410:

Line 1547: hr_utility.trace('Base Element Created');

1543: ,p_effective_date => l_effective_date
1544: ,p_exclusion_rule_id => NULL
1545: );
1546:
1547: hr_utility.trace('Base Element Created');
1548:
1549: --
1550: -- Input Values for 'Base' element.
1551: --

Line 1567: hr_utility.trace('Base Element Input Value - Pay Value Created');

1563: ,p_object_version_number => l_object_version_number
1564: ,p_effective_date => l_effective_date
1565: );
1566:
1567: hr_utility.trace('Base Element Input Value - Pay Value Created');
1568:
1569: pay_siv_ins.ins
1570: (p_input_value_id => l_base_amount_id
1571: ,p_element_type_id => l_base_element_id

Line 1583: hr_utility.trace('Base Element Input Value - Amount Created');

1579: ,p_object_version_number => l_object_version_number
1580: ,p_effective_date => l_effective_date
1581: );
1582:
1583: hr_utility.trace('Base Element Input Value - Amount Created');
1584:
1585:
1586: pay_siv_ins.ins
1587: (p_input_value_id => l_input_value_id

Line 1599: hr_utility.trace('Base Element Input Value- Jurisdiction');

1595: ,p_object_version_number => l_object_version_number
1596: ,p_effective_date => l_effective_date
1597: );
1598:
1599: hr_utility.trace('Base Element Input Value- Jurisdiction');
1600:
1601: --
1602: -- Primary balance types.
1603: --

Line 1622: hr_utility.trace('Primary Balance Type Created.');

1618: ,p_effective_date => l_effective_date
1619: ,p_exclusion_rule_id => NULL
1620: );
1621:
1622: hr_utility.trace('Primary Balance Type Created.');
1623:
1624: pay_sbt_ins.ins
1625: (p_balance_type_id => l_el_balance_id
1626: ,p_template_id => l_template_id

Line 1654: hr_utility.trace('Balance Feed For Primary Balance - Pay Value Created');

1650: ,p_object_version_number => l_object_version_number
1651: ,p_effective_date => l_effective_date
1652: );
1653:
1654: hr_utility.trace('Balance Feed For Primary Balance - Pay Value Created');
1655:
1656: pay_sbf_ins.ins
1657: (p_balance_feed_id => l_balance_feed_id
1658: ,p_balance_type_id => l_el_balance_id

Line 1665: hr_utility.trace('Balance Feed For EL Balance - Pay Value Created');

1661: ,p_object_version_number => l_object_version_number
1662: ,p_effective_date => l_effective_date
1663: );
1664:
1665: hr_utility.trace('Balance Feed For EL Balance - Pay Value Created');
1666:
1667: --
1668: -- Formula rules.
1669: --

Line 1682: hr_utility.trace('Formula Rule - flat_amount created.');

1678: ,p_object_version_number => l_object_version_number
1679: ,p_effective_date => l_effective_date
1680: );
1681:
1682: hr_utility.trace('Formula Rule - flat_amount created.');
1683:
1684: pay_sfr_ins.ins
1685: (p_formula_result_rule_id => l_id
1686: ,p_shadow_element_type_id => l_base_element_id

Line 1694: hr_utility.trace('Formula Rule - mesg created.');

1690: ,p_object_version_number => l_object_version_number
1691: ,p_effective_date => l_effective_date
1692: );
1693:
1694: hr_utility.trace('Formula Rule - mesg created.');
1695:
1696: --
1697: -- Defined Balances for the Primary Balance
1698: --

Line 2036: --hr_utility.trace_on (null,'HXR');

2032:
2033:
2034: begin
2035:
2036: --hr_utility.trace_on (null,'HXR');
2037:
2038:
2039: /* Check for Template Existence */
2040:

Line 2287: hr_utility.trace('Base Element Created');

2283: ,p_effective_date => l_effective_date
2284: ,p_exclusion_rule_id => NULL
2285: );
2286:
2287: hr_utility.trace('Base Element Created');
2288:
2289: --
2290: -- Input Values for 'Base' element.
2291: --

Line 2307: hr_utility.trace('Base Element Input Value - Pay Value Created');

2303: ,p_object_version_number => l_object_version_number
2304: ,p_effective_date => l_effective_date
2305: );
2306:
2307: hr_utility.trace('Base Element Input Value - Pay Value Created');
2308:
2309: pay_siv_ins.ins
2310: (p_input_value_id => l_base_hours_iv_id
2311: ,p_element_type_id => l_base_element_id

Line 2323: hr_utility.trace('Base Element Input Value - Hours Created');

2319: ,p_object_version_number => l_object_version_number
2320: ,p_effective_date => l_effective_date
2321: );
2322:
2323: hr_utility.trace('Base Element Input Value - Hours Created');
2324:
2325: pay_siv_ins.ins
2326: (p_input_value_id => l_base_rate_iv_id
2327: ,p_element_type_id => l_base_element_id

Line 2339: hr_utility.trace('Base Element Input Value - Rate Created');

2335: ,p_object_version_number => l_object_version_number
2336: ,p_effective_date => l_effective_date
2337: );
2338:
2339: hr_utility.trace('Base Element Input Value - Rate Created');
2340:
2341: pay_siv_ins.ins
2342: (p_input_value_id => l_base_multiple_iv_id
2343: ,p_element_type_id => l_base_element_id

Line 2355: hr_utility.trace('Base Element Input Value - Multiple Created');

2351: ,p_object_version_number => l_object_version_number
2352: ,p_effective_date => l_effective_date
2353: );
2354:
2355: hr_utility.trace('Base Element Input Value - Multiple Created');
2356:
2357: pay_siv_ins.ins
2358: (p_input_value_id => l_input_value_id
2359: ,p_element_type_id => l_base_element_id

Line 2370: hr_utility.trace('Base Element Input Value- Jurisdiction');

2366: ,p_object_version_number => l_object_version_number
2367: ,p_effective_date => l_effective_date
2368: );
2369:
2370: hr_utility.trace('Base Element Input Value- Jurisdiction');
2371:
2372: --
2373: -- Primary balance types.
2374: --

Line 2393: hr_utility.trace('Primary Balance Type Created.');

2389: ,p_effective_date => l_effective_date
2390: ,p_exclusion_rule_id => l_excl_el_no_base_bal
2391: );
2392:
2393: hr_utility.trace('Primary Balance Type Created.');
2394:
2395: pay_sbt_ins.ins
2396: (p_balance_type_id => l_hours_bal_typ_id
2397: ,p_template_id => l_template_id

Line 2412: hr_utility.trace('Primary Balance Type Created.');

2408: ,p_effective_date => l_effective_date
2409: ,p_exclusion_rule_id => l_excl_el_no_base_bal
2410: );
2411:
2412: hr_utility.trace('Primary Balance Type Created.');
2413:
2414: pay_sbt_ins.ins
2415: (p_balance_type_id => l_el_bal_typ_id
2416: ,p_template_id => l_template_id

Line 2431: hr_utility.trace('Primary Balance Type Created.');

2427: ,p_effective_date => l_effective_date
2428: ,p_exclusion_rule_id => l_excl_el_no_el_bal
2429: );
2430:
2431: hr_utility.trace('Primary Balance Type Created.');
2432:
2433: --
2434: -- Balance Feeds.
2435: --

Line 2446: hr_utility.trace('Balance Feed - Pay Value Created.');

2442: ,p_object_version_number => l_object_version_number
2443: ,p_effective_date => l_effective_date
2444: );
2445:
2446: hr_utility.trace('Balance Feed - Pay Value Created.');
2447:
2448: pay_sbf_ins.ins
2449: (p_balance_feed_id => l_balance_feed_id
2450: ,p_balance_type_id => l_hours_bal_typ_id

Line 2457: hr_utility.trace('Balance Feed - Hours Created.');

2453: ,p_object_version_number => l_object_version_number
2454: ,p_effective_date => l_effective_date
2455: );
2456:
2457: hr_utility.trace('Balance Feed - Hours Created.');
2458:
2459: pay_sbf_ins.ins
2460: (p_balance_feed_id => l_balance_feed_id
2461: ,p_balance_type_id => l_el_bal_typ_id

Line 2483: hr_utility.trace('Formula Rule - earnings_amount created.');

2479: ,p_object_version_number => l_object_version_number
2480: ,p_effective_date => l_effective_date
2481: );
2482:
2483: hr_utility.trace('Formula Rule - earnings_amount created.');
2484:
2485: /***********
2486: ** This is Indirect result to special feature element for
2487: ** Hours X Rate template check pycaehxr.sql

Line 2501: hr_utility.trace('Formula Rule - earnings_hours created.');

2497: ,p_object_version_number => l_object_version_number
2498: ,p_effective_date => l_effective_date
2499: );
2500:
2501: hr_utility.trace('Formula Rule - earnings_hours created.');
2502:
2503: pay_sfr_ins.ins
2504: (p_formula_result_rule_id => l_id
2505: ,p_shadow_element_type_id => l_base_element_id

Line 2513: hr_utility.trace('Formula Rule - mesg created.');

2509: ,p_object_version_number => l_object_version_number
2510: ,p_effective_date => l_effective_date
2511: );
2512:
2513: hr_utility.trace('Formula Rule - mesg created.');
2514:
2515: --
2516: -- Defined Balances for Primary Balance
2517: --

Line 3008: --hr_utility.trace_on (null,'FLATAMT');

3004:
3005:
3006: begin
3007:
3008: --hr_utility.trace_on (null,'FLATAMT');
3009:
3010:
3011: /* Check for Template Existence */
3012:

Line 3377: hr_utility.trace('Base Element Created');

3373: ,p_effective_date => l_effective_date
3374: ,p_exclusion_rule_id => NULL
3375: );
3376:
3377: hr_utility.trace('Base Element Created');
3378:
3379: --
3380: -- 'Special Features' element.
3381: --

Line 3406: hr_utility.trace('Special Features Element Created');

3402: ,p_object_version_number => l_object_version_number
3403: ,p_effective_date => l_effective_date
3404: );
3405:
3406: hr_utility.trace('Special Features Element Created');
3407:
3408: --
3409: -- Input Values for 'Base' element.
3410: --

Line 3426: hr_utility.trace('Base Element Input Value - Pay Value Created');

3422: ,p_object_version_number => l_object_version_number
3423: ,p_effective_date => l_effective_date
3424: );
3425:
3426: hr_utility.trace('Base Element Input Value - Pay Value Created');
3427:
3428: pay_siv_ins.ins
3429: (p_input_value_id => l_base_percent_id
3430: ,p_element_type_id => l_base_element_id

Line 3442: hr_utility.trace('Base Element Input Value - Amount Created');

3438: ,p_object_version_number => l_object_version_number
3439: ,p_effective_date => l_effective_date
3440: );
3441:
3442: hr_utility.trace('Base Element Input Value - Amount Created');
3443:
3444: pay_siv_ins.ins
3445: (p_input_value_id => l_clear_arr_iv_id
3446: ,p_element_type_id => l_base_element_id

Line 3460: hr_utility.trace('Base Element Input Value - Clear Arrears Created');

3456: ,p_exclusion_rule_id => l_arrearage_rule_id
3457: ,p_effective_date => l_effective_date
3458: );
3459:
3460: hr_utility.trace('Base Element Input Value - Clear Arrears Created');
3461:
3462: pay_siv_ins.ins
3463: (p_input_value_id => l_total_owed_iv_id
3464: ,p_element_type_id => l_base_element_id

Line 3476: hr_utility.trace('Base Element Input Value - Total Owed Created');

3472: ,p_exclusion_rule_id => l_stop_rule_id
3473: ,p_effective_date => l_effective_date
3474: );
3475:
3476: hr_utility.trace('Base Element Input Value - Total Owed Created');
3477:
3478:
3479: --
3480: -- Input Values for 'Special Features' element.

Line 3496: hr_utility.trace('Pay Value for Special Features Created');

3492: ,p_object_version_number => l_object_version_number
3493: ,p_effective_date => l_effective_date
3494: );
3495:
3496: hr_utility.trace('Pay Value for Special Features Created');
3497:
3498: pay_siv_ins.ins
3499: (p_input_value_id => l_sf_accrued_value_id
3500: ,p_element_type_id => l_special_features_element_id

Line 3512: hr_utility.trace('Accrued Input Value for Special Features Created');

3508: ,p_exclusion_rule_id => l_stop_rule_id
3509: ,p_effective_date => l_effective_date
3510: );
3511:
3512: hr_utility.trace('Accrued Input Value for Special Features Created');
3513:
3514: pay_siv_ins.ins
3515: (p_input_value_id => l_sf_not_taken_value_id
3516: ,p_element_type_id => l_special_features_element_id

Line 3527: hr_utility.trace('Not Taken Input Value for Special Features Created');

3523: ,p_object_version_number => l_object_version_number
3524: ,p_effective_date => l_effective_date
3525: );
3526:
3527: hr_utility.trace('Not Taken Input Value for Special Features Created');
3528:
3529: pay_siv_ins.ins
3530: (p_input_value_id => l_sf_arrears_contr_value_id
3531: ,p_element_type_id => l_special_features_element_id

Line 3543: hr_utility.trace('Arrears Contr Input Val for Special Features Created');

3539: ,p_exclusion_rule_id => l_arrearage_rule_id
3540: ,p_effective_date => l_effective_date
3541: );
3542:
3543: hr_utility.trace('Arrears Contr Input Val for Special Features Created');
3544:
3545: --
3546: -- Primary balance types.
3547: --

Line 3565: hr_utility.trace('Primary Balance Type Created.');

3561: ,p_object_version_number => l_object_version_number
3562: ,p_effective_date => l_effective_date
3563: );
3564:
3565: hr_utility.trace('Primary Balance Type Created.');
3566:
3567: pay_sbt_ins.ins
3568: (p_balance_type_id => l_eligible_comp_bal_typ_id
3569: ,p_template_id => l_template_id

Line 3583: hr_utility.trace('Eligible Comp. balance Type Created.');

3579: ,p_object_version_number => l_object_version_number
3580: ,p_effective_date => l_effective_date
3581: );
3582:
3583: hr_utility.trace('Eligible Comp. balance Type Created.');
3584:
3585: pay_sbt_ins.ins
3586: (p_balance_type_id => l_accrued_bal_typ_id
3587: ,p_template_id => l_template_id

Line 3602: hr_utility.trace('Accrued Balance Type Created.');

3598: ,p_effective_date => l_effective_date
3599: );
3600:
3601:
3602: hr_utility.trace('Accrued Balance Type Created.');
3603:
3604: pay_sbt_ins.ins
3605: (p_balance_type_id => l_arrears_bal_typ_id
3606: ,p_template_id => l_template_id

Line 3620: hr_utility.trace('Arrears Balance Type Created.');

3616: ,p_object_version_number => l_object_version_number
3617: ,p_effective_date => l_effective_date
3618: );
3619:
3620: hr_utility.trace('Arrears Balance Type Created.');
3621:
3622: pay_sbt_ins.ins
3623: (p_balance_type_id => l_not_taken_bal_typ_id
3624: ,p_template_id => l_template_id

Line 3638: hr_utility.trace('Not Taken Balance Type Created.');

3634: ,p_object_version_number => l_object_version_number
3635: ,p_effective_date => l_effective_date
3636: );
3637:
3638: hr_utility.trace('Not Taken Balance Type Created.');
3639:
3640: --
3641: -- Balance Feeds.
3642: --

Line 3653: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');

3649: ,p_object_version_number => l_object_version_number
3650: ,p_effective_date => l_effective_date
3651: );
3652:
3653: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');
3654:
3655: pay_sbf_ins.ins
3656: (p_balance_feed_id => l_balance_feed_id
3657: ,p_balance_type_id => l_accrued_bal_typ_id

Line 3664: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');

3660: ,p_object_version_number => l_object_version_number
3661: ,p_effective_date => l_effective_date
3662: );
3663:
3664: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');
3665:
3666: pay_sbf_ins.ins
3667: (p_balance_feed_id => l_balance_feed_id
3668: ,p_balance_type_id => l_not_taken_bal_typ_id

Line 3675: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');

3671: ,p_object_version_number => l_object_version_number
3672: ,p_effective_date => l_effective_date
3673: );
3674:
3675: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');
3676:
3677: pay_sbf_ins.ins
3678: (p_balance_feed_id => l_balance_feed_id
3679: ,p_balance_type_id => l_arrears_bal_typ_id

Line 3686: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');

3682: ,p_object_version_number => l_object_version_number
3683: ,p_effective_date => l_effective_date
3684: );
3685:
3686: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');
3687:
3688: --
3689: -- Formula rules.
3690: --

Line 3703: hr_utility.trace('Formula Rule - dedn_amt created.');

3699: ,p_object_version_number => l_object_version_number
3700: ,p_effective_date => l_effective_date
3701: );
3702:
3703: hr_utility.trace('Formula Rule - dedn_amt created.');
3704:
3705: pay_sfr_ins.ins
3706: (p_formula_result_rule_id => l_id
3707: ,p_shadow_element_type_id => l_base_element_id

Line 3716: hr_utility.trace('Formula Rule - STOP_ENTRY created.');

3712: ,p_object_version_number => l_object_version_number
3713: ,p_effective_date => l_effective_date
3714: );
3715:
3716: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
3717:
3718: pay_sfr_ins.ins
3719: (p_formula_result_rule_id => l_id
3720: ,p_shadow_element_type_id => l_base_element_id

Line 3730: hr_utility.trace('Formula Rule - set_clear created.');

3726: ,p_object_version_number => l_object_version_number
3727: ,p_effective_date => l_effective_date
3728: );
3729:
3730: hr_utility.trace('Formula Rule - set_clear created.');
3731:
3732: pay_sfr_ins.ins
3733: (p_formula_result_rule_id => l_id
3734: ,p_shadow_element_type_id => l_base_element_id

Line 3742: hr_utility.trace('Formula Rule - mesg created.');

3738: ,p_object_version_number => l_object_version_number
3739: ,p_effective_date => l_effective_date
3740: );
3741:
3742: hr_utility.trace('Formula Rule - mesg created.');
3743:
3744: pay_sfr_ins.ins
3745: (p_formula_result_rule_id => l_id
3746: ,p_shadow_element_type_id => l_base_element_id

Line 3755: hr_utility.trace('Formula Rule - to_not_taken created.');

3751: ,p_object_version_number => l_object_version_number
3752: ,p_effective_date => l_effective_date
3753: );
3754:
3755: hr_utility.trace('Formula Rule - to_not_taken created.');
3756:
3757: pay_sfr_ins.ins
3758: (p_formula_result_rule_id => l_id
3759: ,p_shadow_element_type_id => l_base_element_id

Line 3769: hr_utility.trace('Formula Rule - to_total_owed created.');

3765: ,p_object_version_number => l_object_version_number
3766: ,p_effective_date => l_effective_date
3767: );
3768:
3769: hr_utility.trace('Formula Rule - to_total_owed created.');
3770:
3771: pay_sfr_ins.ins
3772: (p_formula_result_rule_id => l_id
3773: ,p_shadow_element_type_id => l_base_element_id

Line 3783: hr_utility.trace('Formula Rule - to_arrears created.');

3779: ,p_object_version_number => l_object_version_number
3780: ,p_effective_date => l_effective_date
3781: );
3782:
3783: hr_utility.trace('Formula Rule - to_arrears created.');
3784:
3785: --
3786: -- Defined Balances
3787: --

Line 4250: --hr_utility.trace_on (null,'PCT');

4246:
4247:
4248: begin
4249:
4250: --hr_utility.trace_on (null,'PCT');
4251:
4252:
4253: /* Check for Template Existence */
4254:

Line 4449: hr_utility.trace('Base Element Created');

4445: ,p_effective_date => l_effective_date
4446: ,p_exclusion_rule_id => NULL
4447: );
4448:
4449: hr_utility.trace('Base Element Created');
4450:
4451: --
4452: -- Input Values for 'Base' element.
4453: --

Line 4469: hr_utility.trace('Base Element Input Value - Pay Value Created');

4465: ,p_object_version_number => l_object_version_number
4466: ,p_effective_date => l_effective_date
4467: );
4468:
4469: hr_utility.trace('Base Element Input Value - Pay Value Created');
4470:
4471: pay_siv_ins.ins
4472: (p_input_value_id => l_base_days_iv_id
4473: ,p_element_type_id => l_base_element_id

Line 4485: hr_utility.trace('Base Element Input Value - Percentage Created');

4481: ,p_object_version_number => l_object_version_number
4482: ,p_effective_date => l_effective_date
4483: );
4484:
4485: hr_utility.trace('Base Element Input Value - Percentage Created');
4486:
4487: pay_siv_ins.ins
4488: (p_input_value_id => l_input_value_id
4489: ,p_element_type_id => l_base_element_id

Line 4500: hr_utility.trace('Base Element Input Value- Jurisdiction');

4496: ,p_object_version_number => l_object_version_number
4497: ,p_effective_date => l_effective_date
4498: );
4499:
4500: hr_utility.trace('Base Element Input Value- Jurisdiction');
4501:
4502: --
4503: -- Primary balance types.
4504: --

Line 4523: hr_utility.trace('Primary Balance Type Created.');

4519: ,p_effective_date => l_effective_date
4520: ,p_exclusion_rule_id => NULL
4521: );
4522:
4523: hr_utility.trace('Primary Balance Type Created.');
4524:
4525: pay_sbt_ins.ins
4526: (p_balance_type_id => l_el_bal_typ_id
4527: ,p_template_id => l_template_id

Line 4542: hr_utility.trace('Employer Liabities Balance Type Created.');

4538: ,p_effective_date => l_effective_date
4539: ,p_exclusion_rule_id => NULL
4540: );
4541:
4542: hr_utility.trace('Employer Liabities Balance Type Created.');
4543:
4544: pay_sbt_ins.ins
4545: (p_balance_type_id => l_ec_bal_typ_id
4546: ,p_template_id => l_template_id

Line 4561: hr_utility.trace('Eligible Comp Balance Type Created.');

4557: ,p_effective_date => l_effective_date
4558: ,p_exclusion_rule_id => NULL
4559: );
4560:
4561: hr_utility.trace('Eligible Comp Balance Type Created.');
4562:
4563: --
4564: -- Balance Feeds.
4565: --

Line 4576: hr_utility.trace('Balance Feed - Pay Value Created.');

4572: ,p_object_version_number => l_object_version_number
4573: ,p_effective_date => l_effective_date
4574: );
4575:
4576: hr_utility.trace('Balance Feed - Pay Value Created.');
4577:
4578: pay_sbf_ins.ins
4579: (p_balance_feed_id => l_balance_feed_id
4580: ,p_balance_type_id => l_el_bal_typ_id

Line 4587: hr_utility.trace('Balance Feed for EL - Pay Value Created.');

4583: ,p_object_version_number => l_object_version_number
4584: ,p_effective_date => l_effective_date
4585: );
4586:
4587: hr_utility.trace('Balance Feed for EL - Pay Value Created.');
4588:
4589: --
4590: -- Formula rules.
4591: --

Line 4604: hr_utility.trace('Formula Rule - earnings_amount created.');

4600: ,p_object_version_number => l_object_version_number
4601: ,p_effective_date => l_effective_date
4602: );
4603:
4604: hr_utility.trace('Formula Rule - earnings_amount created.');
4605:
4606: pay_sfr_ins.ins
4607: (p_formula_result_rule_id => l_id
4608: ,p_shadow_element_type_id => l_base_element_id

Line 4616: hr_utility.trace('Formula Rule - mesg created.');

4612: ,p_object_version_number => l_object_version_number
4613: ,p_effective_date => l_effective_date
4614: );
4615:
4616: hr_utility.trace('Formula Rule - mesg created.');
4617:
4618: --
4619: -- Defined Balances for Primary Balance
4620: --

Line 4964: -- hr_utility.trace_on (null,'FLATAMTDEDN');

4960: ELSE
4961: gv_taxunit_flag := 'N';
4962: END IF;
4963:
4964: -- hr_utility.trace_on (null,'FLATAMTDEDN');
4965: hr_utility.trace('gv_taxunit_flag :'||gv_taxunit_flag);
4966: pay_create_elemnt_tmplt_record.create_earn_flat_amt_templ(p_legislation_code,
4967: p_currency_code);
4968: pay_create_elemnt_tmplt_record.create_earn_pct_amt_templ(p_legislation_code,

Line 4965: hr_utility.trace('gv_taxunit_flag :'||gv_taxunit_flag);

4961: gv_taxunit_flag := 'N';
4962: END IF;
4963:
4964: -- hr_utility.trace_on (null,'FLATAMTDEDN');
4965: hr_utility.trace('gv_taxunit_flag :'||gv_taxunit_flag);
4966: pay_create_elemnt_tmplt_record.create_earn_flat_amt_templ(p_legislation_code,
4967: p_currency_code);
4968: pay_create_elemnt_tmplt_record.create_earn_pct_amt_templ(p_legislation_code,
4969: p_currency_code);