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

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

149: END IF;
150:
151: FOR i IN l_classification_name.FIRST .. l_classification_name.LAST LOOP
152:
153: hr_utility.trace('l_classification_name = ' || l_classification_name(i));
154: l_classification_id := get_classification_id(l_classification_name(i),p_legislation_code);
155:
156: SELECT COUNT(*)
157: INTO ln_exists

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

158: FROM pay_ele_tmplt_class_usages
159: WHERE classification_id = l_classification_id
160: AND template_id = p_template_id;
161:
162: hr_utility.trace('ln_exists = ' || to_char(ln_exists));
163:
164: IF ln_exists = 0 THEN
165:
166: SELECT pay_ele_tmplt_class_usg_s.nextval

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

166: SELECT pay_ele_tmplt_class_usg_s.nextval
167: INTO ln_ele_tmplt_class_id
168: FROM dual;
169:
170: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
171:
172: INSERT INTO pay_ele_tmplt_class_usages
173: ( ele_template_classification_id
174: ,classification_id

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

244:
245:
246: begin
247:
248: --hr_utility.trace_on (null,'FLATAMTDEDN');
249:
250:
251: /* Check for Template Existence */
252:

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

588: ,p_effective_date => l_effective_date
589: ,p_exclusion_rule_id => NULL
590: );
591:
592: hr_utility.trace('Base Element Created');
593:
594: --
595: -- 'Special Features' element.
596: --

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

617: ,p_object_version_number => l_object_version_number
618: ,p_effective_date => l_effective_date
619: );
620:
621: hr_utility.trace('Special Features Element Created');
622:
623: --
624: -- Input Values for 'Base' element.
625: --

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

637: ,p_object_version_number => l_object_version_number
638: ,p_effective_date => l_effective_date
639: );
640:
641: hr_utility.trace('Base Element Input Value - Pay Value Created');
642:
643: pay_siv_ins.ins
644: (p_input_value_id => l_base_amount_id
645: ,p_element_type_id => l_base_element_id

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

653: ,p_object_version_number => l_object_version_number
654: ,p_effective_date => l_effective_date
655: );
656:
657: hr_utility.trace('Base Element Input Value - Amount Created');
658:
659: pay_siv_ins.ins
660: (p_input_value_id => l_clear_arr_iv_id
661: ,p_element_type_id => l_base_element_id

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

671: ,p_exclusion_rule_id => l_arrearage_rule_id
672: ,p_effective_date => l_effective_date
673: );
674:
675: hr_utility.trace('Base Element Input Value - Clear Arrears Created');
676:
677: pay_siv_ins.ins
678: (p_input_value_id => l_total_owed_iv_id
679: ,p_element_type_id => l_base_element_id

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

687: ,p_exclusion_rule_id => l_stop_rule_id
688: ,p_effective_date => l_effective_date
689: );
690:
691: hr_utility.trace('Base Element Input Value - Total Owed Created');
692:
693:
694: --
695: -- Input Values for 'Special Features' element.

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

707: ,p_object_version_number => l_object_version_number
708: ,p_effective_date => l_effective_date
709: );
710:
711: hr_utility.trace('Pay Value for Special Features Created');
712:
713: pay_siv_ins.ins
714: (p_input_value_id => l_sf_accrued_value_id
715: ,p_element_type_id => l_special_features_element_id

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

723: ,p_exclusion_rule_id => l_stop_rule_id
724: ,p_effective_date => l_effective_date
725: );
726:
727: hr_utility.trace('Accrued Input Value for Special Features Created');
728:
729: pay_siv_ins.ins
730: (p_input_value_id => l_sf_not_taken_value_id
731: ,p_element_type_id => l_special_features_element_id

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

738: ,p_object_version_number => l_object_version_number
739: ,p_effective_date => l_effective_date
740: );
741:
742: hr_utility.trace('Not Taken Input Value for Special Features Created');
743:
744: pay_siv_ins.ins
745: (p_input_value_id => l_sf_arrears_contr_value_id
746: ,p_element_type_id => l_special_features_element_id

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

754: ,p_exclusion_rule_id => l_arrearage_rule_id
755: ,p_effective_date => l_effective_date
756: );
757:
758: hr_utility.trace('Arrears Contr Input Value for Spec Features Created');
759:
760: --
761: -- Primary balance types.
762: --

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

776: ,p_object_version_number => l_object_version_number
777: ,p_effective_date => l_effective_date
778: );
779:
780: hr_utility.trace('Primary Balance Type Created.');
781:
782: pay_sbt_ins.ins
783: (p_balance_type_id => l_accrued_bal_typ_id
784: ,p_template_id => l_template_id

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

795: ,p_effective_date => l_effective_date
796: );
797:
798:
799: hr_utility.trace('Accrued Balance Type Created.');
800:
801: pay_sbt_ins.ins
802: (p_balance_type_id => l_arrears_bal_typ_id
803: ,p_template_id => l_template_id

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

813: ,p_object_version_number => l_object_version_number
814: ,p_effective_date => l_effective_date
815: );
816:
817: hr_utility.trace('Arrears Balance Type Created.');
818:
819: pay_sbt_ins.ins
820: (p_balance_type_id => l_not_taken_bal_typ_id
821: ,p_template_id => l_template_id

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

831: ,p_object_version_number => l_object_version_number
832: ,p_effective_date => l_effective_date
833: );
834:
835: hr_utility.trace('Not Taken Balance Type Created.');
836:
837: --
838: -- Balance Feeds.
839: --

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

846: ,p_object_version_number => l_object_version_number
847: ,p_effective_date => l_effective_date
848: );
849:
850: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');
851:
852: pay_sbf_ins.ins
853: (p_balance_feed_id => l_balance_feed_id
854: ,p_balance_type_id => l_accrued_bal_typ_id

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

857: ,p_object_version_number => l_object_version_number
858: ,p_effective_date => l_effective_date
859: );
860:
861: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');
862:
863: pay_sbf_ins.ins
864: (p_balance_feed_id => l_balance_feed_id
865: ,p_balance_type_id => l_not_taken_bal_typ_id

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

869: ,p_object_version_number => l_object_version_number
870: ,p_effective_date => l_effective_date
871: );
872:
873: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');
874:
875: pay_sbf_ins.ins
876: (p_balance_feed_id => l_balance_feed_id
877: ,p_balance_type_id => l_arrears_bal_typ_id

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

881: ,p_object_version_number => l_object_version_number
882: ,p_effective_date => l_effective_date
883: );
884:
885: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');
886:
887: --
888: -- Formula rules.
889: --

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

898: ,p_object_version_number => l_object_version_number
899: ,p_effective_date => l_effective_date
900: );
901:
902: hr_utility.trace('Formula Rule - dedn_amt created.');
903:
904: pay_sfr_ins.ins
905: (p_formula_result_rule_id => l_id
906: ,p_shadow_element_type_id => l_base_element_id

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

911: ,p_object_version_number => l_object_version_number
912: ,p_effective_date => l_effective_date
913: );
914:
915: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
916:
917: pay_sfr_ins.ins
918: (p_formula_result_rule_id => l_id
919: ,p_shadow_element_type_id => l_base_element_id

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

925: ,p_object_version_number => l_object_version_number
926: ,p_effective_date => l_effective_date
927: );
928:
929: hr_utility.trace('Formula Rule - set_clear created.');
930:
931: pay_sfr_ins.ins
932: (p_formula_result_rule_id => l_id
933: ,p_shadow_element_type_id => l_base_element_id

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

937: ,p_object_version_number => l_object_version_number
938: ,p_effective_date => l_effective_date
939: );
940:
941: hr_utility.trace('Formula Rule - mesg created.');
942:
943: pay_sfr_ins.ins
944: (p_formula_result_rule_id => l_id
945: ,p_shadow_element_type_id => l_base_element_id

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

950: ,p_object_version_number => l_object_version_number
951: ,p_effective_date => l_effective_date
952: );
953:
954: hr_utility.trace('Formula Rule - to_not_taken created.');
955:
956: pay_sfr_ins.ins
957: (p_formula_result_rule_id => l_id
958: ,p_shadow_element_type_id => l_base_element_id

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

964: ,p_object_version_number => l_object_version_number
965: ,p_effective_date => l_effective_date
966: );
967:
968: hr_utility.trace('Formula Rule - to_total_owed created.');
969:
970: pay_sfr_ins.ins
971: (p_formula_result_rule_id => l_id
972: ,p_shadow_element_type_id => l_base_element_id

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

978: ,p_object_version_number => l_object_version_number
979: ,p_effective_date => l_effective_date
980: );
981:
982: hr_utility.trace('Formula Rule - to_arrears created.');
983:
984: --
985: -- Defined Balances for Base Balance
986: --

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

1181:
1182:
1183: begin
1184:
1185: --hr_utility.trace_on (null,'FLATAMT');
1186:
1187:
1188: /* Check for Template Existence */
1189:

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

1322: ,p_effective_date => l_effective_date
1323: ,p_exclusion_rule_id => NULL
1324: );
1325:
1326: hr_utility.trace('Base Element Created');
1327:
1328: --
1329: -- Input Values for 'Base' element.
1330: --

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

1342: ,p_object_version_number => l_object_version_number
1343: ,p_effective_date => l_effective_date
1344: );
1345:
1346: hr_utility.trace('Base Element Input Value - Pay Value Created');
1347:
1348: pay_siv_ins.ins
1349: (p_input_value_id => l_base_amount_id
1350: ,p_element_type_id => l_base_element_id

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

1358: ,p_object_version_number => l_object_version_number
1359: ,p_effective_date => l_effective_date
1360: );
1361:
1362: hr_utility.trace('Base Element Input Value - Amount Created');
1363:
1364:
1365: pay_siv_ins.ins
1366: (p_input_value_id => l_input_value_id

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

1374: ,p_object_version_number => l_object_version_number
1375: ,p_effective_date => l_effective_date
1376: );
1377:
1378: hr_utility.trace('Base Element Input Value- Jurisdiction');
1379:
1380: --
1381: -- Primary balance types.
1382: --

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

1397: ,p_effective_date => l_effective_date
1398: ,p_exclusion_rule_id => NULL
1399: );
1400:
1401: hr_utility.trace('Primary Balance Type Created.');
1402:
1403: pay_sbt_ins.ins
1404: (p_balance_type_id => l_el_balance_id
1405: ,p_template_id => l_template_id

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

1429: ,p_object_version_number => l_object_version_number
1430: ,p_effective_date => l_effective_date
1431: );
1432:
1433: hr_utility.trace('Balance Feed For Primary Balance - Pay Value Created');
1434:
1435: pay_sbf_ins.ins
1436: (p_balance_feed_id => l_balance_feed_id
1437: ,p_balance_type_id => l_el_balance_id

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

1440: ,p_object_version_number => l_object_version_number
1441: ,p_effective_date => l_effective_date
1442: );
1443:
1444: hr_utility.trace('Balance Feed For EL Balance - Pay Value Created');
1445:
1446: --
1447: -- Formula rules.
1448: --

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

1457: ,p_object_version_number => l_object_version_number
1458: ,p_effective_date => l_effective_date
1459: );
1460:
1461: hr_utility.trace('Formula Rule - flat_amount created.');
1462:
1463: pay_sfr_ins.ins
1464: (p_formula_result_rule_id => l_id
1465: ,p_shadow_element_type_id => l_base_element_id

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

1469: ,p_object_version_number => l_object_version_number
1470: ,p_effective_date => l_effective_date
1471: );
1472:
1473: hr_utility.trace('Formula Rule - mesg created.');
1474:
1475: --
1476: -- Defined Balances for the Primary Balance
1477: --

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

1651:
1652:
1653: begin
1654:
1655: --hr_utility.trace_on (null,'HXR');
1656:
1657:
1658: /* Check for Template Existence */
1659:

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

1902: ,p_effective_date => l_effective_date
1903: ,p_exclusion_rule_id => NULL
1904: );
1905:
1906: hr_utility.trace('Base Element Created');
1907:
1908: --
1909: -- Input Values for 'Base' element.
1910: --

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

1922: ,p_object_version_number => l_object_version_number
1923: ,p_effective_date => l_effective_date
1924: );
1925:
1926: hr_utility.trace('Base Element Input Value - Pay Value Created');
1927:
1928: pay_siv_ins.ins
1929: (p_input_value_id => l_base_hours_iv_id
1930: ,p_element_type_id => l_base_element_id

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

1938: ,p_object_version_number => l_object_version_number
1939: ,p_effective_date => l_effective_date
1940: );
1941:
1942: hr_utility.trace('Base Element Input Value - Hours Created');
1943:
1944: pay_siv_ins.ins
1945: (p_input_value_id => l_base_rate_iv_id
1946: ,p_element_type_id => l_base_element_id

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

1954: ,p_object_version_number => l_object_version_number
1955: ,p_effective_date => l_effective_date
1956: );
1957:
1958: hr_utility.trace('Base Element Input Value - Rate Created');
1959:
1960: pay_siv_ins.ins
1961: (p_input_value_id => l_base_multiple_iv_id
1962: ,p_element_type_id => l_base_element_id

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

1970: ,p_object_version_number => l_object_version_number
1971: ,p_effective_date => l_effective_date
1972: );
1973:
1974: hr_utility.trace('Base Element Input Value - Multiple Created');
1975:
1976: pay_siv_ins.ins
1977: (p_input_value_id => l_input_value_id
1978: ,p_element_type_id => l_base_element_id

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

1985: ,p_object_version_number => l_object_version_number
1986: ,p_effective_date => l_effective_date
1987: );
1988:
1989: hr_utility.trace('Base Element Input Value- Jurisdiction');
1990:
1991: --
1992: -- Primary balance types.
1993: --

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

2008: ,p_effective_date => l_effective_date
2009: ,p_exclusion_rule_id => l_excl_el_no_base_bal
2010: );
2011:
2012: hr_utility.trace('Primary Balance Type Created.');
2013:
2014: pay_sbt_ins.ins
2015: (p_balance_type_id => l_hours_bal_typ_id
2016: ,p_template_id => l_template_id

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

2027: ,p_effective_date => l_effective_date
2028: ,p_exclusion_rule_id => l_excl_el_no_base_bal
2029: );
2030:
2031: hr_utility.trace('Primary Balance Type Created.');
2032:
2033: pay_sbt_ins.ins
2034: (p_balance_type_id => l_el_bal_typ_id
2035: ,p_template_id => l_template_id

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

2046: ,p_effective_date => l_effective_date
2047: ,p_exclusion_rule_id => l_excl_el_no_el_bal
2048: );
2049:
2050: hr_utility.trace('Primary Balance Type Created.');
2051:
2052: --
2053: -- Balance Feeds.
2054: --

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

2061: ,p_object_version_number => l_object_version_number
2062: ,p_effective_date => l_effective_date
2063: );
2064:
2065: hr_utility.trace('Balance Feed - Pay Value Created.');
2066:
2067: pay_sbf_ins.ins
2068: (p_balance_feed_id => l_balance_feed_id
2069: ,p_balance_type_id => l_hours_bal_typ_id

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

2072: ,p_object_version_number => l_object_version_number
2073: ,p_effective_date => l_effective_date
2074: );
2075:
2076: hr_utility.trace('Balance Feed - Hours Created.');
2077:
2078: pay_sbf_ins.ins
2079: (p_balance_feed_id => l_balance_feed_id
2080: ,p_balance_type_id => l_el_bal_typ_id

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

2098: ,p_object_version_number => l_object_version_number
2099: ,p_effective_date => l_effective_date
2100: );
2101:
2102: hr_utility.trace('Formula Rule - earnings_amount created.');
2103:
2104: /***********
2105: ** This is Indirect result to special feature element for
2106: ** Hours X Rate template check pycaehxr.sql

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

2116: ,p_object_version_number => l_object_version_number
2117: ,p_effective_date => l_effective_date
2118: );
2119:
2120: hr_utility.trace('Formula Rule - earnings_hours created.');
2121:
2122: pay_sfr_ins.ins
2123: (p_formula_result_rule_id => l_id
2124: ,p_shadow_element_type_id => l_base_element_id

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

2128: ,p_object_version_number => l_object_version_number
2129: ,p_effective_date => l_effective_date
2130: );
2131:
2132: hr_utility.trace('Formula Rule - mesg created.');
2133:
2134: --
2135: -- Defined Balances for Primary Balance
2136: --

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

2415:
2416:
2417: begin
2418:
2419: --hr_utility.trace_on (null,'FLATAMT');
2420:
2421:
2422: /* Check for Template Existence */
2423:

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

2784: ,p_effective_date => l_effective_date
2785: ,p_exclusion_rule_id => NULL
2786: );
2787:
2788: hr_utility.trace('Base Element Created');
2789:
2790: --
2791: -- 'Special Features' element.
2792: --

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

2813: ,p_object_version_number => l_object_version_number
2814: ,p_effective_date => l_effective_date
2815: );
2816:
2817: hr_utility.trace('Special Features Element Created');
2818:
2819: --
2820: -- Input Values for 'Base' element.
2821: --

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

2833: ,p_object_version_number => l_object_version_number
2834: ,p_effective_date => l_effective_date
2835: );
2836:
2837: hr_utility.trace('Base Element Input Value - Pay Value Created');
2838:
2839: pay_siv_ins.ins
2840: (p_input_value_id => l_base_percent_id
2841: ,p_element_type_id => l_base_element_id

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

2849: ,p_object_version_number => l_object_version_number
2850: ,p_effective_date => l_effective_date
2851: );
2852:
2853: hr_utility.trace('Base Element Input Value - Amount Created');
2854:
2855: pay_siv_ins.ins
2856: (p_input_value_id => l_clear_arr_iv_id
2857: ,p_element_type_id => l_base_element_id

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

2867: ,p_exclusion_rule_id => l_arrearage_rule_id
2868: ,p_effective_date => l_effective_date
2869: );
2870:
2871: hr_utility.trace('Base Element Input Value - Clear Arrears Created');
2872:
2873: pay_siv_ins.ins
2874: (p_input_value_id => l_total_owed_iv_id
2875: ,p_element_type_id => l_base_element_id

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

2883: ,p_exclusion_rule_id => l_stop_rule_id
2884: ,p_effective_date => l_effective_date
2885: );
2886:
2887: hr_utility.trace('Base Element Input Value - Total Owed Created');
2888:
2889:
2890: --
2891: -- Input Values for 'Special Features' element.

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

2903: ,p_object_version_number => l_object_version_number
2904: ,p_effective_date => l_effective_date
2905: );
2906:
2907: hr_utility.trace('Pay Value for Special Features Created');
2908:
2909: pay_siv_ins.ins
2910: (p_input_value_id => l_sf_accrued_value_id
2911: ,p_element_type_id => l_special_features_element_id

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

2919: ,p_exclusion_rule_id => l_stop_rule_id
2920: ,p_effective_date => l_effective_date
2921: );
2922:
2923: hr_utility.trace('Accrued Input Value for Special Features Created');
2924:
2925: pay_siv_ins.ins
2926: (p_input_value_id => l_sf_not_taken_value_id
2927: ,p_element_type_id => l_special_features_element_id

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

2934: ,p_object_version_number => l_object_version_number
2935: ,p_effective_date => l_effective_date
2936: );
2937:
2938: hr_utility.trace('Not Taken Input Value for Special Features Created');
2939:
2940: pay_siv_ins.ins
2941: (p_input_value_id => l_sf_arrears_contr_value_id
2942: ,p_element_type_id => l_special_features_element_id

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

2950: ,p_exclusion_rule_id => l_arrearage_rule_id
2951: ,p_effective_date => l_effective_date
2952: );
2953:
2954: hr_utility.trace('Arrears Contr Input Val for Special Features Created');
2955:
2956: --
2957: -- Primary balance types.
2958: --

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

2972: ,p_object_version_number => l_object_version_number
2973: ,p_effective_date => l_effective_date
2974: );
2975:
2976: hr_utility.trace('Primary Balance Type Created.');
2977:
2978: pay_sbt_ins.ins
2979: (p_balance_type_id => l_eligible_comp_bal_typ_id
2980: ,p_template_id => l_template_id

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

2990: ,p_object_version_number => l_object_version_number
2991: ,p_effective_date => l_effective_date
2992: );
2993:
2994: hr_utility.trace('Eligible Comp. balance Type Created.');
2995:
2996: pay_sbt_ins.ins
2997: (p_balance_type_id => l_accrued_bal_typ_id
2998: ,p_template_id => l_template_id

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

3009: ,p_effective_date => l_effective_date
3010: );
3011:
3012:
3013: hr_utility.trace('Accrued Balance Type Created.');
3014:
3015: pay_sbt_ins.ins
3016: (p_balance_type_id => l_arrears_bal_typ_id
3017: ,p_template_id => l_template_id

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

3027: ,p_object_version_number => l_object_version_number
3028: ,p_effective_date => l_effective_date
3029: );
3030:
3031: hr_utility.trace('Arrears Balance Type Created.');
3032:
3033: pay_sbt_ins.ins
3034: (p_balance_type_id => l_not_taken_bal_typ_id
3035: ,p_template_id => l_template_id

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

3045: ,p_object_version_number => l_object_version_number
3046: ,p_effective_date => l_effective_date
3047: );
3048:
3049: hr_utility.trace('Not Taken Balance Type Created.');
3050:
3051: --
3052: -- Balance Feeds.
3053: --

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

3060: ,p_object_version_number => l_object_version_number
3061: ,p_effective_date => l_effective_date
3062: );
3063:
3064: hr_utility.trace('Balance Feed - Pay Value to Primary Bal Created.');
3065:
3066: pay_sbf_ins.ins
3067: (p_balance_feed_id => l_balance_feed_id
3068: ,p_balance_type_id => l_accrued_bal_typ_id

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

3071: ,p_object_version_number => l_object_version_number
3072: ,p_effective_date => l_effective_date
3073: );
3074:
3075: hr_utility.trace('Balance Feed - Accrued to Accrued Bal Created.');
3076:
3077: pay_sbf_ins.ins
3078: (p_balance_feed_id => l_balance_feed_id
3079: ,p_balance_type_id => l_not_taken_bal_typ_id

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

3082: ,p_object_version_number => l_object_version_number
3083: ,p_effective_date => l_effective_date
3084: );
3085:
3086: hr_utility.trace('Balance Feed - Not Taken to Not Taken Bal Created.');
3087:
3088: pay_sbf_ins.ins
3089: (p_balance_feed_id => l_balance_feed_id
3090: ,p_balance_type_id => l_arrears_bal_typ_id

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

3093: ,p_object_version_number => l_object_version_number
3094: ,p_effective_date => l_effective_date
3095: );
3096:
3097: hr_utility.trace('Balance Feed - Arrears Contr to Arrears Bal Created.');
3098:
3099: --
3100: -- Formula rules.
3101: --

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

3110: ,p_object_version_number => l_object_version_number
3111: ,p_effective_date => l_effective_date
3112: );
3113:
3114: hr_utility.trace('Formula Rule - dedn_amt created.');
3115:
3116: pay_sfr_ins.ins
3117: (p_formula_result_rule_id => l_id
3118: ,p_shadow_element_type_id => l_base_element_id

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

3123: ,p_object_version_number => l_object_version_number
3124: ,p_effective_date => l_effective_date
3125: );
3126:
3127: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
3128:
3129: pay_sfr_ins.ins
3130: (p_formula_result_rule_id => l_id
3131: ,p_shadow_element_type_id => l_base_element_id

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

3137: ,p_object_version_number => l_object_version_number
3138: ,p_effective_date => l_effective_date
3139: );
3140:
3141: hr_utility.trace('Formula Rule - set_clear created.');
3142:
3143: pay_sfr_ins.ins
3144: (p_formula_result_rule_id => l_id
3145: ,p_shadow_element_type_id => l_base_element_id

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

3149: ,p_object_version_number => l_object_version_number
3150: ,p_effective_date => l_effective_date
3151: );
3152:
3153: hr_utility.trace('Formula Rule - mesg created.');
3154:
3155: pay_sfr_ins.ins
3156: (p_formula_result_rule_id => l_id
3157: ,p_shadow_element_type_id => l_base_element_id

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

3162: ,p_object_version_number => l_object_version_number
3163: ,p_effective_date => l_effective_date
3164: );
3165:
3166: hr_utility.trace('Formula Rule - to_not_taken created.');
3167:
3168: pay_sfr_ins.ins
3169: (p_formula_result_rule_id => l_id
3170: ,p_shadow_element_type_id => l_base_element_id

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

3176: ,p_object_version_number => l_object_version_number
3177: ,p_effective_date => l_effective_date
3178: );
3179:
3180: hr_utility.trace('Formula Rule - to_total_owed created.');
3181:
3182: pay_sfr_ins.ins
3183: (p_formula_result_rule_id => l_id
3184: ,p_shadow_element_type_id => l_base_element_id

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

3190: ,p_object_version_number => l_object_version_number
3191: ,p_effective_date => l_effective_date
3192: );
3193:
3194: hr_utility.trace('Formula Rule - to_arrears created.');
3195:
3196: --
3197: -- Defined Balances
3198: --

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

3443:
3444:
3445: begin
3446:
3447: --hr_utility.trace_on (null,'PCT');
3448:
3449:
3450: /* Check for Template Existence */
3451:

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

3642: ,p_effective_date => l_effective_date
3643: ,p_exclusion_rule_id => NULL
3644: );
3645:
3646: hr_utility.trace('Base Element Created');
3647:
3648: --
3649: -- Input Values for 'Base' element.
3650: --

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

3662: ,p_object_version_number => l_object_version_number
3663: ,p_effective_date => l_effective_date
3664: );
3665:
3666: hr_utility.trace('Base Element Input Value - Pay Value Created');
3667:
3668: pay_siv_ins.ins
3669: (p_input_value_id => l_base_days_iv_id
3670: ,p_element_type_id => l_base_element_id

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

3678: ,p_object_version_number => l_object_version_number
3679: ,p_effective_date => l_effective_date
3680: );
3681:
3682: hr_utility.trace('Base Element Input Value - Percentage Created');
3683:
3684: pay_siv_ins.ins
3685: (p_input_value_id => l_input_value_id
3686: ,p_element_type_id => l_base_element_id

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

3693: ,p_object_version_number => l_object_version_number
3694: ,p_effective_date => l_effective_date
3695: );
3696:
3697: hr_utility.trace('Base Element Input Value- Jurisdiction');
3698:
3699: --
3700: -- Primary balance types.
3701: --

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

3716: ,p_effective_date => l_effective_date
3717: ,p_exclusion_rule_id => NULL
3718: );
3719:
3720: hr_utility.trace('Primary Balance Type Created.');
3721:
3722: pay_sbt_ins.ins
3723: (p_balance_type_id => l_el_bal_typ_id
3724: ,p_template_id => l_template_id

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

3735: ,p_effective_date => l_effective_date
3736: ,p_exclusion_rule_id => NULL
3737: );
3738:
3739: hr_utility.trace('Employer Liabities Balance Type Created.');
3740:
3741: pay_sbt_ins.ins
3742: (p_balance_type_id => l_ec_bal_typ_id
3743: ,p_template_id => l_template_id

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

3754: ,p_effective_date => l_effective_date
3755: ,p_exclusion_rule_id => NULL
3756: );
3757:
3758: hr_utility.trace('Eligible Comp Balance Type Created.');
3759:
3760: --
3761: -- Balance Feeds.
3762: --

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

3769: ,p_object_version_number => l_object_version_number
3770: ,p_effective_date => l_effective_date
3771: );
3772:
3773: hr_utility.trace('Balance Feed - Pay Value Created.');
3774:
3775: pay_sbf_ins.ins
3776: (p_balance_feed_id => l_balance_feed_id
3777: ,p_balance_type_id => l_el_bal_typ_id

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

3780: ,p_object_version_number => l_object_version_number
3781: ,p_effective_date => l_effective_date
3782: );
3783:
3784: hr_utility.trace('Balance Feed for EL - Pay Value Created.');
3785:
3786: --
3787: -- Formula rules.
3788: --

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

3797: ,p_object_version_number => l_object_version_number
3798: ,p_effective_date => l_effective_date
3799: );
3800:
3801: hr_utility.trace('Formula Rule - earnings_amount created.');
3802:
3803: pay_sfr_ins.ins
3804: (p_formula_result_rule_id => l_id
3805: ,p_shadow_element_type_id => l_base_element_id

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

3809: ,p_object_version_number => l_object_version_number
3810: ,p_effective_date => l_effective_date
3811: );
3812:
3813: hr_utility.trace('Formula Rule - mesg created.');
3814:
3815: --
3816: -- Defined Balances for Primary Balance
3817: --

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

3971:
3972: procedure create_all_templates(p_legislation_code in varchar2, p_currency_code in varchar2) is
3973: Begin
3974:
3975: -- hr_utility.trace_on (null,'FLATAMTDEDN');
3976: pay_create_elemnt_tmplt_record.create_earn_flat_amt_templ(p_legislation_code,
3977: p_currency_code);
3978: pay_create_elemnt_tmplt_record.create_earn_pct_amt_templ(p_legislation_code,
3979: p_currency_code);