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_ELEMENT_TYPES_PKG dependencies on PAY_ELEMENT_TYPES_PKG

Line 1: package body PAY_ELEMENT_TYPES_PKG as

1: package body PAY_ELEMENT_TYPES_PKG as
2: /* $Header: pyelt.pkb 120.6.12010000.2 2008/08/06 07:09:44 ubhat ship $ */
3: --
4: --------------------------------------------------------------------------------
5: -- Declaration of package-wide (global) variables and cursors

Line 86: l_package_name VARCHAR2(80) := 'PAY_ELEMENT_TYPES_PKG.VALIDATE_TRANSLATION';

82: AND ( et.element_type_id <> p_element_type_id OR p_element_type_id is null)
83: AND ( g_business_group_id = et.business_group_id + 0 OR g_business_group_id is null )
84: AND ( g_legislation_code = et.legislation_code OR g_legislation_code is null );
85:
86: l_package_name VARCHAR2(80) := 'PAY_ELEMENT_TYPES_PKG.VALIDATE_TRANSLATION';
87: l_dummy varchar2(100);
88: l_name pay_element_types.element_name%type := element_name;
89:
90: BEGIN

Line 183: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RECREATE_DB_ITEMS',1);

179: ) is
180: --
181: begin
182: --
183: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RECREATE_DB_ITEMS',1);
184: --
185: -- Drop the DB items
186: hrdyndbi.delete_element_type_dict(p_element_type_id);
187: --

Line 340: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',1);

336: --
337: --
338: begin
339: --
340: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',1);
341: --
342: open csr_new_id;
343: fetch csr_new_id into p_element_type_id;
344: close csr_new_id;

Line 582: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',2);

578: --
579: -- Return the new rowid, and retrieve the newly generated element type
580: -- identifier into the forms row to avoid needing to requery
581: --
582: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',2);
583: --
584: open csr_element_rowid;
585: fetch csr_element_rowid into p_rowid;
586: if (csr_element_rowid%notfound) then

Line 589: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.INSERT_ROW');

585: fetch csr_element_rowid into p_rowid;
586: if (csr_element_rowid%notfound) then
587: close csr_element_rowid;
588: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
589: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.INSERT_ROW');
590: end if;
591: close csr_element_rowid;
592: --
593: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',3);

Line 593: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',3);

589: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.INSERT_ROW');
590: end if;
591: close csr_element_rowid;
592: --
593: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',3);
594: --
595: -- Create element DB items on the entity horizon
596: hrdyndbi.create_element_type_dict(p_element_type_id,
597: p_effective_start_date);

Line 599: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',4);

595: -- Create element DB items on the entity horizon
596: hrdyndbi.create_element_type_dict(p_element_type_id,
597: p_effective_start_date);
598: --
599: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',4);
600: --
601: -- Create pay value for payment type elements which will be processed in the
602: -- payroll run
603: if (p_process_in_run_flag = 'Y' and p_non_payments_flag = 'N') then

Line 690: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',5);

686: p_uom => p_default_benefit_uom);
687: --
688: end if;
689: --
690: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.INSERT_ROW',5);
691: --
692: pay_sub_class_rules_pkg.insert_defaults (
693: --
694: p_element_type_id,

Line 825: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.UPDATE_ROW',1);

821: is
822: --
823: begin
824: --
825: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.UPDATE_ROW',1);
826: --
827: update pay_element_types_f
828: set
829: element_type_id = p_element_type_id,

Line 928: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UPDATE_ROW');

924: where rowid = p_rowid;
925: --
926: if (sql%notfound) then -- trap system errors during update
927: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
928: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UPDATE_ROW');
929: end if;
930: --
931: --
932: -- ****************************************************************************************

Line 951: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UPDATE_TL_ROW');

947: --
948: --
949: if (sql%notfound) then -- trap system errors during update
950: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
951: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UPDATE_TL_ROW');
952: end if;
953: --
954: -- ***************************************************************************************
955: --

Line 1002: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',1);

998: p_delete_mode ) then
999: --
1000: -- Cascade deletion through child entities
1001: --
1002: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',1);
1003: --
1004: pay_input_values_pkg.parent_deleted ( p_element_type_id,
1005: p_session_date,
1006: p_validation_start_date,

Line 1010: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',2);

1006: p_validation_start_date,
1007: p_validation_end_date,
1008: p_delete_mode );
1009: --
1010: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',2);
1011: --
1012: ben_benefit_contributions_pkg.parent_deleted ( p_element_type_id,
1013: p_delete_mode,
1014: p_session_date,

Line 1017: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',3);

1013: p_delete_mode,
1014: p_session_date,
1015: c_base_table );
1016: --
1017: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',3);
1018: --
1019: pay_sub_class_rules_pkg.parent_deleted ( p_element_type_id,
1020: p_session_date,
1021: p_validation_start_date,

Line 1026: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',4);

1022: p_validation_end_date,
1023: p_delete_mode,
1024: c_base_table );
1025: --
1026: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',4);
1027: --
1028: pay_status_rules_pkg.parent_deleted ( p_element_type_id,
1029: p_session_date,
1030: p_delete_mode );

Line 1058: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',5);

1054: and start_date > p_session_date;
1055: --
1056: end if;
1057: --
1058: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',5);
1059: --
1060: -- Delete the element itself
1061: delete
1062: from pay_element_types_f

Line 1067: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.DELETE_ROW');

1063: where rowid = p_rowid;
1064: --
1065: if sql%notfound then -- trap system errors during deletion
1066: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1067: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.DELETE_ROW');
1068: end if;
1069: --
1070: -- ****************************************************************************
1071: --

Line 1085: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.DELETE_TL_ROW');

1081: where ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID;
1082: --
1083: if sql%notfound then -- trap system errors during deletion
1084: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1085: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.DELETE_TL_ROW');
1086: end if;
1087:
1088: end if;
1089: --

Line 1237: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW',10);

1233: l_time_definition_type pay_element_types_f.time_definition_type%type;
1234: --
1235: begin
1236: --
1237: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW',10);
1238: --
1239: -- Fetching the row effectively locks it because of the 'for update' clause
1240: open csr_element_type;
1241: fetch csr_element_type into element_record;

Line 1246: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.LOCK_ROW');

1242: --
1243: if (csr_element_type%notfound) then -- Trap system errors
1244: close csr_element_type;
1245: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1246: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.LOCK_ROW');
1247: end if;
1248: --
1249: close csr_element_type;
1250: --

Line 1262: -- hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW:'||to_char(l_count),15);

1258: -- code for MLS
1259: --
1260: --for tlinfo in csr_element_type_tl LOOP
1261: -- l_count := l_count+1;
1262: -- hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW:'||to_char(l_count),15);
1263: -- if (tlinfo.BASELANG = 'Y') then
1264: -- if ( (tlinfo.ELEMENT_NAME = P_ELEMENT_NAME)
1265: -- AND ((tlinfo.REPORTING_NAME = P_REPORTING_NAME)
1266: -- OR ((tlinfo.REPORTING_NAME is null) AND (P_REPORTING_NAME is null)))

Line 1279: -- hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.LOCK_ROW');

1275: -- end if;
1276: --end loop;
1277: --IF(l_count=0) THEN -- We have data missing from the _TL table.
1278: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1279: -- hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_TYPES_PKG.LOCK_ROW');
1280: --end if;
1281: --
1282: -- ***************************************************************************
1283: --

Line 1295: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW',20);

1291: -- parser stack limitations. It checks to see if any column
1292: -- showing in the form has been changed by another user prior
1293: -- to this user changing it and since the row was queried
1294: --
1295: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW',20);
1296: --
1297:
1298: -- Bug 6411503. Checking for time_definition_type
1299: select DECODE(element_record.time_definition_type, 'N', NULL, element_record.TIME_DEFINITION_TYPE)

Line 1401: --hr_utility.set_location ('pay_element_types_pkg.lock_row',30);

1397: -- hr_utility.set_message('fnd', 'form_record_changed');
1398: -- hr_utility.raise_error;
1399: --end if;
1400: --
1401: --hr_utility.set_location ('pay_element_types_pkg.lock_row',30);
1402: --
1403: --if
1404: --
1405: --((element_record.element_information20 = p_element_information20)

Line 1526: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DATE_EFFECTIVELY_UPDATED',1);

1522: and rowid <> p_rowid;
1523: --
1524: begin
1525: --
1526: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DATE_EFFECTIVELY_UPDATED',1);
1527: --
1528: open csr_dated_updates;
1529: fetch csr_dated_updates into g_dummy_number;
1530: v_dated_updates := csr_dated_updates%found;

Line 1575: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.STOP_ENTRY_RULES_EXIST',1);

1571: and frr.effective_start_date between p_validation_start_date
1572: and p_validation_end_date;
1573: begin
1574: --
1575: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.STOP_ENTRY_RULES_EXIST',1);
1576: --
1577: open csr_stop_entry_rules;
1578: fetch csr_stop_entry_rules into g_dummy_number;
1579: v_stop_entry_rules := csr_stop_entry_rules%found;

Line 1658: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',1);

1654: and payroll.effective_date between p_validation_start_date
1655: and p_validation_end_date);
1656: --
1657: begin
1658: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',1);
1659: /* Check if the element type has any input values */
1660:
1661: open csr_input_values;
1662: fetch csr_input_values into v_input_value_id;

Line 1669: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',5);

1665:
1666: /* If input values exist use the input value to check if run result
1667: values exists. */
1668:
1669: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',5);
1670:
1671: if v_input_values_exist then
1672: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',10);
1673: open csr_run_result_values(v_input_value_id);

Line 1672: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',10);

1668:
1669: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',5);
1670:
1671: if v_input_values_exist then
1672: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',10);
1673: open csr_run_result_values(v_input_value_id);
1674: fetch csr_run_result_values into g_dummy_number;
1675: v_run_results_exist := csr_run_result_values%found;
1676: close csr_run_result_values;

Line 1678: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',15);

1674: fetch csr_run_result_values into g_dummy_number;
1675: v_run_results_exist := csr_run_result_values%found;
1676: close csr_run_result_values;
1677: else
1678: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',15);
1679: open csr_run_results;
1680: fetch csr_run_results into g_dummy_number;
1681: v_run_results_exist := csr_run_results%found;
1682: close csr_run_results;

Line 1685: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',20);

1681: v_run_results_exist := csr_run_results%found;
1682: close csr_run_results;
1683: end if;
1684:
1685: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.RUN_RESULTS_EXIST',20);
1686: if v_run_results_exist and p_error_if_true then
1687: --
1688: if p_DML_action_being_checked = 'UPDATE' then
1689: hr_utility.set_message (801,'PAY_6909_ELEMENT_NO_UPD_RR');

Line 1723: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.FED_BY_INDIRECT_RESULTS',1);

1719: v_fed_by_indirect_results boolean;
1720: --
1721: begin
1722: --
1723: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.FED_BY_INDIRECT_RESULTS',1);
1724: --
1725: -- Find formula result rules of type Indirect ('I')
1726: open g_csr_result_rules ( p_element_type_id,
1727: p_validation_start_date,

Line 1774: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.UPDATE_RECURRING_RULES_EXIST',1);

1770: and status_processing_rule_id = v_status_processing_rule_id;
1771: --
1772: begin
1773: --
1774: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.UPDATE_RECURRING_RULES_EXIST',1);
1775: --
1776: -- Find formula result rules of type Update Recurring ('U')
1777: open g_csr_result_rules ( p_element_type_id,
1778: p_validation_start_date,

Line 1878: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',1);

1874: p_stop_entry_rules out nocopy boolean) is
1875: --
1876: begin
1877: --
1878: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',1);
1879: --
1880: -- Perform individual checks and place results directly in the OUT parameters
1881: --
1882: p_run_results := run_results_exist ( p_element_type_id,

Line 1886: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',2);

1882: p_run_results := run_results_exist ( p_element_type_id,
1883: p_validation_start_date,
1884: p_validation_end_date);
1885: --
1886: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',2);
1887: --
1888: p_element_links := links_exist ( p_element_type_id,
1889: p_validation_start_date,
1890: p_validation_end_date );

Line 1893: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',3);

1889: p_validation_start_date,
1890: p_validation_end_date );
1891:
1892: --
1893: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',3);
1894: --
1895: p_indirect_results := fed_by_indirect_results ( p_element_type_id,
1896: p_validation_start_date,
1897: p_validation_end_date);

Line 1899: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',4);

1895: p_indirect_results := fed_by_indirect_results ( p_element_type_id,
1896: p_validation_start_date,
1897: p_validation_end_date);
1898: --
1899: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',4);
1900: --
1901: p_dated_updates := date_effectively_updated ( p_element_type_id,
1902: p_rowid);
1903: --

Line 1904: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',5);

1900: --
1901: p_dated_updates := date_effectively_updated ( p_element_type_id,
1902: p_rowid);
1903: --
1904: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',5);
1905: --
1906: p_stop_entry_rules := stop_entry_rules_exist ( p_element_type_id,
1907: p_validation_start_date,
1908: p_validation_end_date);

Line 1910: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',6);

1906: p_stop_entry_rules := stop_entry_rules_exist ( p_element_type_id,
1907: p_validation_start_date,
1908: p_validation_end_date);
1909: --
1910: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',6);
1911: --
1912: p_update_recurring := update_recurring_rules_exist (p_element_type_id,
1913: p_validation_start_date,
1914: p_validation_end_date);

Line 1916: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',6);

1912: p_update_recurring := update_recurring_rules_exist (p_element_type_id,
1913: p_validation_start_date,
1914: p_validation_end_date);
1915: --
1916: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',6);
1917: --
1918: p_pay_basis := element_used_as_pay_basis (p_element_type_id);
1919: --
1920: end check_relationships;

Line 1948: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_IS_IN_AN_ELEMENT_SET',1);

1944: where element_type_id = p_element_type_id;
1945: --
1946: begin
1947: --
1948: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_IS_IN_AN_ELEMENT_SET',1);
1949: --
1950: open csr_element_set;
1951: fetch csr_element_set into g_dummy_number;
1952: v_in_set := csr_element_set%found;

Line 1999: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LINKS_EXIST',1);

1995: and effective_start_date <= p_validation_end_date;
1996: --
1997: begin
1998: --
1999: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LINKS_EXIST',1);
2000: --
2001: open csr_links;
2002: fetch csr_links into g_dummy_number;
2003: v_links_exist := csr_links%found;

Line 2046: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ACCRUAL_PLAN_EXISTS',1);

2042: where accrual_plan_element_type_id = p_element_type_id;
2043: --
2044: begin
2045: --
2046: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ACCRUAL_PLAN_EXISTS',1);
2047: --
2048: open csr_accrual;
2049: fetch csr_accrual into g_dummy_number;
2050: v_accrual_exists := csr_accrual%found;

Line 2093: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.COBRA_BENEFITS_EXIST',1);

2089: and effective_end_date >= p_validation_start_date;
2090: --
2091: begin
2092: --
2093: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.COBRA_BENEFITS_EXIST',1);
2094: --
2095: open csr_cobra;
2096: fetch csr_cobra into g_dummy_number;
2097: v_cobra_exists := csr_cobra%found;

Line 2138: ('PAY_ELEMENT_TYPES_PKG.benefit_contributions_exist',1);

2134: --
2135: begin
2136: --
2137: hr_utility.set_location
2138: ('PAY_ELEMENT_TYPES_PKG.benefit_contributions_exist',1);
2139: --
2140: open csr_contribution;
2141: fetch csr_contribution into g_dummy_number;
2142: v_contribution_exists := csr_contribution%found;

Line 2174: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETION_ALLOWED',1);

2170: v_deletion_allowed boolean := TRUE;
2171: --
2172: begin
2173: --
2174: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETION_ALLOWED',1);
2175: --
2176: -- Check business rules relating to deletion of element type
2177: --
2178: if (p_delete_mode = 'DELETE_NEXT_CHANGE'

Line 2304: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_PRIORITY_TOO_HIGH',1);

2300: and result.effective_start_date <= p_validation_end_date);
2301: --
2302: begin
2303: --
2304: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_PRIORITY_TOO_HIGH',1);
2305: --
2306: open csr_elements_fed_by_this_one;
2307: fetch csr_elements_fed_by_this_one into g_dummy_number;
2308: v_priority_too_high := csr_elements_fed_by_this_one%found;

Line 2364: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_PRIORITY_TOO_LOW',1);

2360: and result.effective_start_date<= p_validation_end_date);
2361: --
2362: begin
2363: --
2364: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_PRIORITY_TOO_LOW',1);
2365: --
2366: open csr_elements_feeding_this_one;
2367: fetch csr_elements_feeding_this_one into g_dummy_number;
2368: v_priority_too_low := csr_elements_feeding_this_one%found;

Line 2405: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.PRIORITY_RESULT_RULE_VIOLATED',1);

2401: v_priority_rule_violated boolean := FALSE;
2402: --
2403: begin
2404: --
2405: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.PRIORITY_RESULT_RULE_VIOLATED',1);
2406: --
2407: if element_priority_too_high ( p_element_type_id,
2408: p_processing_priority,
2409: p_validation_start_date,

Line 2471: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.NAME_IS_NOT_UNIQUE',1);

2467: and et_tl.language = userenv('LANG');
2468: --
2469: begin
2470: --
2471: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.NAME_IS_NOT_UNIQUE',1);
2472: --
2473: open csr_duplicate;
2474: fetch csr_duplicate into g_dummy_number;
2475: v_name_duplicated := csr_duplicate%found;

Line 2558: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_ENTRIES_EXIST',1);

2554: and link.element_type_id = p_element_type_id;
2555: --
2556: begin
2557: --
2558: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.ELEMENT_ENTRIES_EXIST',1);
2559: --
2560: open csr_entries;
2561: fetch csr_entries into g_dummy_number;
2562: v_entries_exist := csr_entries%found;

Line 2669: hr_utility.set_message_token('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UNIQUE_CHK');

2665: and BUSINESS_GROUP_ID is NULL;
2666: --
2667: IF (result>1) THEN
2668: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2669: hr_utility.set_message_token('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UNIQUE_CHK');
2670: hr_utility.set_message_token('STEP','1');
2671: hr_utility.raise_error;
2672: END IF;
2673: EXCEPTION

Line 2676: hr_utility.set_message_token('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UNIQUE_CHK');

2672: END IF;
2673: EXCEPTION
2674: when NO_DATA_FOUND then
2675: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2676: hr_utility.set_message_token('PROCEDURE','PAY_ELEMENT_TYPES_PKG.UNIQUE_CHK');
2677: hr_utility.set_message_token('STEP','1');
2678: hr_utility.raise_error;
2679: end unique_chk;
2680: --------------------------------------------------------------------------------

Line 2784: end PAY_ELEMENT_TYPES_PKG;

2780:
2781: c_user_id := fnd_global.user_id;
2782: c_login_id := fnd_global.login_id;
2783:
2784: end PAY_ELEMENT_TYPES_PKG;