APPS.PAY_IP_STARTUP_UTIL dependencies on HR_UTILITY

Line 298: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);

294: l_Installed number := 0;
295: l_reference number := 0;
296:
297: BEGIN
298: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
299: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
300: --for the given legislation and if no other patch is getting applied
301: --and reference data is available.
302:

Line 352: hr_utility.set_location('pay_ip_startup_util.check_to_install',20);

348: RETURN v_check_installation ;
349: END IF;
350:
351: RETURN v_check_installation ;
352: hr_utility.set_location('pay_ip_startup_util.check_to_install',20);
353: END check_to_install;
354:
355: -- ---------------------------------------------------------------------
356: -- Function to check if

Line 403: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',10);

399: -- ---------------------------------------------------------------------
400: PROCEDURE clear_shadow_tables IS
401:
402: BEGIN
403: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',10);
404: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_FORMULA_TYPES',NULL);
405: DELETE hr_s_formula_types;
406: COMMIT;
407:

Line 669: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',20);

665:
666: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);
667: DELETE HR_S_STATE_RULES;
668: COMMIT;
669: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',20);
670: END clear_shadow_tables;
671:
672:
673: -- -----------------------------------------------------------------------

Line 801: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);

797: AND pbd.balance_dimension_id = pdr.balance_dimension_id;
798:
799:
800: BEGIN
801: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
802: --Legislation Rules
803: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
804:
805: INSERT INTO hr_s_application_ownerships

Line 943: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables',20);

939: ----pay_ip_startup_util.insert_ownership('CLASSIFICATION_ID','PAY',rec.classification_id);
940:
941: END LOOP;
942:
943: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables',20);
944: --Balance Types
945: write_log('LOG',NULL,NULL,NULL);
946: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
947: FOR rec IN get_balance_type_csr LOOP

Line 1037: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',30);

1033: ----pay_ip_startup_util.insert_ownership('BALANCE_TYPE_ID','PER',rec.balance_type_id);
1034: --pay_ip_startup_util.insert_ownership('BALANCE_TYPE_ID','PAY',rec.balance_type_id);
1035: END LOOP;
1036:
1037: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',30);
1038:
1039: --Defined Balance
1040: write_log('LOG',NULL,NULL,NULL);
1041: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');

Line 1079: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',40);

1075: );
1076:
1077: END LOOP;
1078:
1079: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',40);
1080:
1081: --Balance Dimensions
1082:
1083: write_log('LOG',NULL,NULL,NULL);

Line 1134: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',50);

1130: ----write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Dimension', rec.dimension_name);
1131:
1132: END LOOP;
1133:
1134: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',50);
1135:
1136: --Routes
1137:
1138: write_log('LOG',NULL,NULL,NULL);

Line 1255: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',60);

1251: END IF;
1252:
1253:
1254:
1255: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',60);
1256: -- Route Parameters
1257: write_log('LOG',NULL,NULL,NULL);
1258: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Parameters', 'HR_S_ROUTE_PARAMETERS');
1259: INSERT INTO hr_s_route_parameters

Line 1282: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',70);

1278: WHERE EXISTS ( SELECT NULL
1279: FROM hr_s_routes b
1280: WHERE b.route_id = a.route_id));
1281:
1282: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',70);
1283:
1284: -- Used column to column mapping in the insert statement to remove
1285: -- error caused by mismatch in number of fields. Bug No 3720975.
1286:

Line 1308: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',80);

1304: RULE_MODE
1305: FROM pay_legislative_field_info
1306: WHERE nvl(legislation_code,'X') = 'ZZ');
1307:
1308: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',80);
1309:
1310: --Balance Classifications
1311:
1312: write_log('LOG',NULL,NULL,NULL);

Line 1352: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',90);

1348: ----write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Classifications', rec.balance_classification_id);
1349:
1350: END LOOP;
1351:
1352: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',90);
1353:
1354: --Balance Classifications
1355:
1356: write_log('LOG',NULL,NULL,NULL);

Line 1460: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',100);

1456:
1457: ----write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Categories', rec.balance_category_id);
1458:
1459: END LOOP;
1460: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',100);
1461:
1462: /*Adding entries to pay_report_format_mappings*/
1463: FOR rec IN c_get_report_format_mappings LOOP
1464: fnd_file.put_line(fnd_file.LOG,'Moving report_format_mappings to shadow table');

Line 1520: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',90);

1516: END LOOP;
1517: fnd_file.put_line(fnd_file.LOG,'Finished moving report_format_mappings to shadow table');
1518: fnd_file.put_line(fnd_file.OUTPUT,'Finished moving report_format_mappings to shadow table');
1519:
1520: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',90);
1521:
1522: EXCEPTION
1523: WHEN OTHERS THEN
1524: IF get_element_class_csr%ISOPEN THEN

Line 1592: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);

1588: INTO l_application_id
1589: FROM FND_APPLICATION
1590: WHERE application_short_name = p_appl_Short_Name;
1591:
1592: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1593: fnd_flex_key_api.set_session_mode('seed_data');
1594:
1595: l_flexfield := fnd_flex_key_api.find_flexfield
1596: ( appl_short_name => p_appl_short_name,

Line 1599: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);

1595: l_flexfield := fnd_flex_key_api.find_flexfield
1596: ( appl_short_name => p_appl_short_name,
1597: flex_code => p_flex_code );
1598:
1599: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);
1600: BEGIN
1601:
1602: l_structure := fnd_flex_key_api.find_structure
1603: ( flexfield => l_flexfield,

Line 1607: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',30);

1603: ( flexfield => l_flexfield,
1604: structure_code => p_structure_code );
1605:
1606: return l_structure.structure_number;
1607: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',30);
1608: EXCEPTION
1609: WHEN NO_DATA_FOUND THEN
1610:
1611: -- Bug 4544374. Check if the structure code exists with this title already.

Line 1658: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',40);

1654: structure => l_structure );
1655:
1656: RETURN l_structure.structure_number;
1657: END;
1658: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',40);
1659: END create_key_flexfield;
1660:
1661: -- ---------------------------------------------------------------------
1662: -- Procedure for creating the Flex field segments

Line 1690: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);

1686: l_flex_num NUMBER(15);
1687: l_segment fnd_flex_key_api.segment_type;
1688: BEGIN
1689:
1690: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1691: fnd_flex_key_api.set_session_mode('seed_data');
1692: l_flexfield := fnd_flex_key_api.find_flexfield
1693: ( appl_short_name => p_appl_short_name,
1694: flex_code => p_flex_code );

Line 1696: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);

1692: l_flexfield := fnd_flex_key_api.find_flexfield
1693: ( appl_short_name => p_appl_short_name,
1694: flex_code => p_flex_code );
1695:
1696: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);
1697:
1698: l_structure := fnd_flex_key_api.find_structure
1699: ( flexfield => l_flexfield,
1700: structure_code => p_structure_code );

Line 1702: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);

1698: l_structure := fnd_flex_key_api.find_structure
1699: ( flexfield => l_flexfield,
1700: structure_code => p_structure_code );
1701:
1702: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1703: begin
1704:
1705: hr_utility.trace(p_segment_name);
1706: l_segment := fnd_flex_key_api.find_segment

Line 1705: hr_utility.trace(p_segment_name);

1701:
1702: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1703: begin
1704:
1705: hr_utility.trace(p_segment_name);
1706: l_segment := fnd_flex_key_api.find_segment
1707: (
1708: flexfield => l_flexfield
1709: ,structure => l_structure

Line 1737: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);

1733: ,lov_prompt => p_lov_prompt
1734: ,window_prompt => p_window_prompt
1735: );
1736:
1737: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1738:
1739: hr_utility.trace(p_segment_name);
1740: begin
1741: fnd_flex_key_api.add_segment

Line 1739: hr_utility.trace(p_segment_name);

1735: );
1736:
1737: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1738:
1739: hr_utility.trace(p_segment_name);
1740: begin
1741: fnd_flex_key_api.add_segment
1742: (
1743: flexfield => l_flexfield

Line 1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));

1745: ,segment => l_segment
1746: );
1747: exception
1748: when others then
1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1750: end;
1751: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1752: fnd_flex_key_api.assign_qualifier
1753: (

Line 1751: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);

1747: exception
1748: when others then
1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1750: end;
1751: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1752: fnd_flex_key_api.assign_qualifier
1753: (
1754: flexfield => l_flexfield
1755: ,structure => l_structure

Line 1776: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',10);

1772: p_Rule_Type IN VARCHAR2,
1773: p_Rule_mode IN VARCHAR2) IS
1774:
1775: BEGIN
1776: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',10);
1777:
1778: INSERT INTO hr_s_legislation_rules
1779: ( legislation_code
1780: ,rule_type

Line 1797: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',20);

1793: rule_mode = p_rule_mode
1794: WHERE legislation_code = 'ZZ'
1795: AND rule_type = p_rule_type;
1796: END IF;
1797: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',20);
1798: END;
1799:
1800: -- ---------------------------------------------------------------------
1801: -- HR_S Tables are updated to the choosen legislation_code and currency

Line 1808: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);

1804: (p_legislation_code IN VARCHAR2,
1805: p_currency_code IN VARCHAR2) IS
1806:
1807: BEGIN
1808: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1809: --Updating Element Classifications Table
1810:
1811: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1812: UPDATE hr_s_element_classifications

Line 1872: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',20);

1868: UPDATE hr_s_balance_categories_f
1869: SET legislation_code = p_legislation_code
1870: WHERE legislation_code = 'ZZ';
1871:
1872: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',20);
1873:
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

Line 1888: hr_utility.set_location('pay_ip_startup_util.insert_history_table',10);

1884: PROCEDURE insert_history_table
1885: (p_legislation_code IN VARCHAR2) IS
1886:
1887: BEGIN
1888: hr_utility.set_location('pay_ip_startup_util.insert_history_table',10);
1889: INSERT INTO hr_s_history
1890: ( package_name
1891: ,date_of_export
1892: ,date_of_import

Line 1901: hr_utility.set_location('pay_ip_startup_util.insert_history_table',20);

1897: ,sysdate
1898: ,sysdate
1899: ,'HR_S tabes copied from reference account'
1900: ,p_legislation_code);
1901: hr_utility.set_location('pay_ip_startup_util.insert_history_table',20);
1902: END insert_history_table ;
1903:
1904: PROCEDURE create_report_format_param(p_legislation_code IN VARCHAR2) IS
1905:

Line 1925: hr_utility.set_location('pay_ip_startup_util.create_report_format_param',10);

1921: ln_report_mapping_id NUMBER;
1922: lv_legislation_code VARCHAR2(4);
1923:
1924: BEGIN
1925: hr_utility.set_location('pay_ip_startup_util.create_report_format_param',10);
1926:
1927: OPEN c_report_format_mapping;
1928: FETCH c_report_format_mapping INTO ln_report_mapping_id;
1929:

Line 1960: hr_utility.set_location('pay_ip_startup_util.create_report_format_param',20);

1956: (ln_report_mapping_id, rec.parameter_name, rec.parameter_value);
1957: END IF;
1958:
1959: END LOOP;
1960: hr_utility.set_location('pay_ip_startup_util.create_report_format_param',20);
1961:
1962: END create_report_format_param;
1963:
1964: -- ---------------------------------------------------------------------

Line 1971: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',10);

1967: -- ---------------------------------------------------------------------
1968: PROCEDURE move_to_main_tables IS
1969:
1970: BEGIN
1971: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',10);
1972: hr_legislation.install;
1973:
1974: EXCEPTION
1975: WHEN OTHERS THEN

Line 1978: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',20);

1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
1977:
1978: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',20);
1979: END move_to_main_tables;
1980:
1981: -- ---------------------------------------------------------------------
1982: -- Procedure to update the TL tables with the translated values.

Line 2012: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',10);

2008: rec_tltable_csr get_classid_tltable_csr%ROWTYPE;
2009:
2010: BEGIN
2011:
2012: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',10);
2013:
2014: FOR l_record in get_classid_btable_csr LOOP
2015:
2016: OPEN get_classid_tltable_csr(p_legislation_code, l_record.bname, l_record.language);

Line 2043: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',20);

2039: IF get_classid_tltable_csr%ISOPEN THEN
2040: CLOSE get_classid_tltable_csr;
2041: END IF;
2042: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
2043: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',20);
2044: END update_ele_class_tl;
2045:
2046: PROCEDURE update_bal_categories_tl
2047: (p_legislation_code IN VARCHAR2) IS

Line 2071: hr_utility.set_location('pay_ip_startup_util.update_bal_categories_tl',10);

2067: rec_tltable_csr get_balcat_tltable_csr%ROWTYPE;
2068:
2069: BEGIN
2070:
2071: hr_utility.set_location('pay_ip_startup_util.update_bal_categories_tl',10);
2072:
2073: FOR l_record in get_balcat_btable_csr LOOP
2074:
2075: OPEN get_balcat_tltable_csr(p_legislation_code, l_record.bname, l_record.language);

Line 2101: hr_utility.set_location('pay_ip_startup_util.update_bal_categories_tl',20);

2097: IF get_balcat_tltable_csr%ISOPEN THEN
2098: CLOSE get_balcat_tltable_csr;
2099: END IF;
2100: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
2101: hr_utility.set_location('pay_ip_startup_util.update_bal_categories_tl',20);
2102: END update_bal_categories_tl;
2103:
2104: -- Updating Balance Types TL Table
2105:

Line 2131: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',10);

2127:
2128: rec_tltable_csr get_balid_tltable_csr%ROWTYPE;
2129:
2130: BEGIN
2131: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',10);
2132:
2133: FOR l_record in get_balid_btable_csr LOOP
2134:
2135: OPEN get_balid_tltable_csr(p_legislation_code, l_record.bname, l_record.language);

Line 2164: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',20);

2160: END IF;
2161:
2162: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
2163:
2164: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',20);
2165:
2166: END update_bal_type_tl;
2167:
2168: PROCEDURE create_runtype

Line 2250: hr_utility.set_location('pay_ip_startup_util.create_runtype',10);

2246:
2247: BEGIN
2248: -- Run Types
2249:
2250: hr_utility.set_location('pay_ip_startup_util.create_runtype',10);
2251:
2252: write_log('LOG',NULL,NULL,NULL);
2253: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_RUN_TYPE_API',NULL);
2254:

Line 2293: hr_utility.set_location('pay_ip_startup_util.create_runtype',20);

2289: END LOOP;
2290:
2291: -- Run Type Usages
2292:
2293: hr_utility.set_location('pay_ip_startup_util.create_runtype',20);
2294:
2295: write_log('LOG',NULL,NULL,NULL);
2296: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_RUN_TYPE_USAGE_API',NULL);
2297:

Line 2345: hr_utility.set_location('pay_ip_startup_util.create_runtype',30);

2341:
2342: END LOOP; --child
2343: END LOOP; --parent
2344:
2345: hr_utility.set_location('pay_ip_startup_util.create_runtype',30);
2346:
2347: EXCEPTION
2348: WHEN OTHERS THEN
2349: IF run_type_csr%ISOPEN THEN

Line 2379: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',10);

2375: AND business_group_id IS NULL;
2376: --
2377: BEGIN
2378: --
2379: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',10);
2380:
2381: write_log('LOG',NULL,NULL,NULL);
2382: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Attribute Definitions', 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
2383:

Line 2400: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',20);

2396: );
2397:
2398: END LOOP;
2399:
2400: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',20);
2401: --
2402: EXCEPTION
2403: when others then
2404: if get_bal_att_def%isopen then

Line 2440: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',10);

2436: rec_tltable_csr get_runid_tltable_csr%ROWTYPE;
2437:
2438: BEGIN
2439:
2440: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',10);
2441:
2442: FOR l_record in get_runid_btable_csr LOOP
2443:
2444: OPEN get_runid_tltable_csr(p_legislation_code, l_record.bname, l_record.language) ;

Line 2462: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',20);

2458: CLOSE get_runid_tltable_csr;
2459:
2460: END LOOP;
2461:
2462: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',20);
2463: EXCEPTION
2464: WHEN OTHERS THEN
2465: IF get_runid_btable_csr%ISOPEN THEN
2466: CLOSE get_runid_btable_csr;

Line 2531: hr_utility.trace('Error: ' || sqlerrm);

2527: RETURN l_retro_definition_id;
2528: --
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: hr_utility.trace('Error: ' || sqlerrm);
2532: rollback;
2533: hr_utility.raise_error;
2534: END create_retro_definitions;
2535:

Line 2533: hr_utility.raise_error;

2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: hr_utility.trace('Error: ' || sqlerrm);
2532: rollback;
2533: hr_utility.raise_error;
2534: END create_retro_definitions;
2535:
2536: --------------------------------------------------------------------------
2537: -- Function to create retro components

Line 2611: hr_utility.trace('Error: ' || sqlerrm);

2607: RETURN l_retro_component_id;
2608: --
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: hr_utility.trace('Error: ' || sqlerrm);
2612: rollback;
2613: hr_utility.raise_error;
2614: END create_retro_components;
2615: --

Line 2613: hr_utility.raise_error;

2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: hr_utility.trace('Error: ' || sqlerrm);
2612: rollback;
2613: hr_utility.raise_error;
2614: END create_retro_components;
2615: --
2616: --------------------------------------------------------------------------
2617: -- Function to create retro definition components

Line 2679: hr_utility.trace('Error: ' || sqlerrm);

2675: RETURN l_definition_component_id;
2676: --
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: hr_utility.trace('Error: ' || sqlerrm);
2680: rollback;
2681: hr_utility.raise_error;
2682: END create_retro_defn_components;
2683: --

Line 2681: hr_utility.raise_error;

2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: hr_utility.trace('Error: ' || sqlerrm);
2680: rollback;
2681: hr_utility.raise_error;
2682: END create_retro_defn_components;
2683: --
2684: --------------------------------------------------------------------------
2685: -- Function to create time definitions

Line 2764: hr_utility.trace('Error: ' || sqlerrm);

2760: RETURN l_time_definition_id;
2761: --
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: hr_utility.trace('Error: ' || sqlerrm);
2765: rollback;
2766: hr_utility.raise_error;
2767: END create_time_definitions;
2768: --------------------------------------------------------------------------

Line 2766: hr_utility.raise_error;

2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: hr_utility.trace('Error: ' || sqlerrm);
2765: rollback;
2766: hr_utility.raise_error;
2767: END create_time_definitions;
2768: --------------------------------------------------------------------------
2769: -- Function to create time spans
2770: -- If the creator_id and creator_type combination already exists

Line 2835: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);

2831: RETURN l_time_span_id;
2832: --
2833: EXCEPTION
2834: WHEN OTHERS THEN
2835: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2836: rollback;
2837: hr_utility.raise_error;
2838: --
2839: END create_time_spans;

Line 2837: hr_utility.raise_error;

2833: EXCEPTION
2834: WHEN OTHERS THEN
2835: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2836: rollback;
2837: hr_utility.raise_error;
2838: --
2839: END create_time_spans;
2840:
2841: -- Creating Retro definition,components and time spans

Line 2970: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',10);

2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;
2967:
2968: BEGIN
2969:
2970: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',10);
2971:
2972: ltt_short_name(1) := 'IP_ELEMENT_INFO_CAT_UPGRADE_'||upper(p_legislation_code);
2973: ltt_gen_short_name(1) := 'IP_ELEMENT_INFO_CAT_UPGRADE_ZZ';
2974: ltt_short_name(2) := 'IP_RETRO_ELEMENT_UPGRADE_'||upper(p_legislation_code);

Line 2989: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',20);

2985: CLOSE csr_gen_upg_exists;
2986:
2987: IF lv_gen_upg_exists = 'N' THEN
2988:
2989: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',20);
2990:
2991: OPEN csr_get_gen_upg_values (ltt_gen_short_name(i));
2992: FETCH csr_get_gen_upg_values INTO lv_short_name,
2993: lv_name,

Line 3032: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',30);

3028: P_UPGRADE_DEFINITION_ID => ln_upg_id);
3029:
3030: ELSE
3031:
3032: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',30);
3033:
3034: hr_utility.trace ('The Generic Upgrade Mechanism already exists for this localization');
3035:
3036: END IF;

Line 3034: hr_utility.trace ('The Generic Upgrade Mechanism already exists for this localization');

3030: ELSE
3031:
3032: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',30);
3033:
3034: hr_utility.trace ('The Generic Upgrade Mechanism already exists for this localization');
3035:
3036: END IF;
3037:
3038: END LOOP;

Line 3069: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',10);

3065: and fff.function_name = cp_function_name
3066: and fmu.menu_name = cp_menu_name;
3067:
3068: BEGIN
3069: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',10);
3070: lv_menu_entry_exists :='N';
3071: lv_fnd_menu_name := 'HR_'||p_legislation_code||'_SS_FUNCTIONS_SEED';
3072:
3073: OPEN csr_menu_entry_exists (lv_fnd_menu_name,p_function_name);

Line 3078: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',20);

3074: FETCH csr_menu_entry_exists INTO lv_menu_entry_exists;
3075: CLOSE csr_menu_entry_exists;
3076:
3077: IF lv_menu_entry_exists = 'N' THEN
3078: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',20);
3079:
3080: /*
3081: Bug#14349456 : Creating Entry for the function PAY_IP_VIEW_EMPBAL_SS -
3082: (View Employee Balance Page).

Line 3085: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',30);

3081: Bug#14349456 : Creating Entry for the function PAY_IP_VIEW_EMPBAL_SS -
3082: (View Employee Balance Page).
3083: */
3084: IF p_function_name = 'PAY_IP_VIEW_EMPBAL_SS' THEN
3085: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',30);
3086: pay_ip_utility.create_fnd_menu_entry(
3087: p_mode => 'MERGE_NOOVERWRITE',
3088: p_menu_name => lv_fnd_menu_name,
3089: p_sub_menu_name => null,

Line 3096: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',40);

3092: p_prompt => NULL,
3093: p_description => NULL,
3094: p_owner => 'ORACLE');
3095: END IF;
3096: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',40);
3097: END IF;
3098:
3099: EXCEPTION
3100: WHEN OTHERS THEN

Line 3101: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',50);

3097: END IF;
3098:
3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: hr_utility.set_location('pay_ip_startup_util.create_fnd_menu_entry ',50);
3102: raise_application_error(-20001, SQLERRM);
3103: END create_fnd_menu_entry;
3104:
3105: -- ----------------------------------------------------------------------

Line 3154: hr_utility.set_location('pay_ip_startup_util.setup',10);

3150: where id_flex_code = 'SCL'
3151: and id_flex_num = p_id_flex_num;
3152:
3153: BEGIN
3154: hr_utility.set_location('pay_ip_startup_util.setup',10);
3155:
3156: /* Change the values of these patch variables whenever
3157: a patch updating route_id in table pay_balance_dimensions
3158: or pay_dimension_routes for existing balance dimensions

Line 3183: hr_utility.set_location('pay_ip_startup_util.setup',20);

3179: DELETE FROM HR_STU_EXCEPTIONS;
3180:
3181: --Clearing all HRMS HR_S tables
3182: write_log('OUTPUT','PAY_34022_IP_LEG_INS_BEGINS', l_territory_with_code ,to_char(sysdate,'dd-Mon-yyyy hh:mi:ss'));
3183: hr_utility.set_location('pay_ip_startup_util.setup',20);
3184: write_log('LOG',NULL,NULL,NULL);
3185: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S%',NULL);
3186: clear_shadow_tables;
3187:

Line 3189: hr_utility.set_location('pay_ip_startup_util.setup',25);

3185: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S%',NULL);
3186: clear_shadow_tables;
3187:
3188: --Inserting ownerships
3189: hr_utility.set_location('pay_ip_startup_util.setup',25);
3190: write_log('LOG',NULL,NULL,NULL);
3191: pay_ip_utility.insert_all_ownerships;
3192:
3193: --Moving data to shadow table

Line 3195: hr_utility.set_location('pay_ip_startup_util.setup',30);

3191: pay_ip_utility.insert_all_ownerships;
3192:
3193: --Moving data to shadow table
3194:
3195: hr_utility.set_location('pay_ip_startup_util.setup',30);
3196: write_log('LOG',NULL,NULL,NULL);
3197: write_log('LOG','PAY_34009_IP_MOVE_TO_HR_S',NULL,NULL);
3198: move_to_shadow_tables(p_legislation_code, p_install_tax_unit);
3199:

Line 3305: hr_utility.set_location('pay_ip_startup_util.setup',40);

3301: create_leg_rule(p_legislation_code => p_legislation_code,
3302: p_rule_type => 'TAX_UNIT',
3303: p_rule_mode => 'Y');
3304:
3305: hr_utility.set_location('pay_ip_startup_util.setup',40);
3306: write_log('LOG',NULL,NULL,NULL);
3307: write_log('LOG','PAY_34007_IP_CREATE_FLEX',p_Legislation_Code ||
3308: '_STATUTORY_INFO', NULL);
3309:

Line 3390: hr_utility.set_location('pay_ip_startup_util.setup',50);

3386: p_lov_prompt => 'Tax Unit',
3387: p_window_prompt => 'Tax Unit');
3388: END IF;
3389:
3390: hr_utility.set_location('pay_ip_startup_util.setup',50);
3391: END IF;
3392:
3393: --Create FlexField
3394:

Line 3395: hr_utility.set_location('pay_ip_startup_util.setup',40);

3391: END IF;
3392:
3393: --Create FlexField
3394:
3395: hr_utility.set_location('pay_ip_startup_util.setup',40);
3396: write_log('LOG',NULL,NULL,NULL);
3397: write_log('LOG','PAY_34007_IP_CREATE_FLEX',p_Legislation_Code || '_BANK_DETAILS', NULL);
3398: l_id_flex_num := create_key_flexfield
3399: (p_appl_short_name => 'PAY',

Line 3414: hr_utility.set_location('pay_ip_startup_util.setup',50);

3410: p_shorthand_enabled_flag => 'N',
3411: p_shorthand_prompt => '',
3412: p_shorthand_length => 10);
3413:
3414: hr_utility.set_location('pay_ip_startup_util.setup',50);
3415: write_log('LOG','PAY_34008_IP_INS_LEG_RULE',p_Legislation_Code || '_BANK_DETAILS', NULL);
3416: create_leg_rule
3417: (p_legislation_code => p_legislation_code,
3418: p_rule_type => 'E',

Line 3462: hr_utility.set_location('pay_ip_startup_util.setup',55);

3458: ,p_ORG_INFORMATION_TYPE => p_Legislation_Code||'_REPORTING_PREFERENCES'
3459: ,p_MANDATORY_FLAG => 'N');
3460:
3461: --Moving Payroll exception reporting dimensions
3462: hr_utility.set_location('pay_ip_startup_util.setup',55);
3463: pay_ip_utility.create_pqp_rep_dim
3464: (p_legislation_code => p_legislation_code,
3465: p_install_tax_unit => p_install_tax_unit,
3466: p_tax_year => p_Tax_Year);

Line 3469: hr_utility.set_location('pay_ip_startup_util.setup',60);

3465: p_install_tax_unit => p_install_tax_unit,
3466: p_tax_year => p_Tax_Year);
3467:
3468: --Updating shadow table
3469: hr_utility.set_location('pay_ip_startup_util.setup',60);
3470: write_log('LOG',NULL,NULL,NULL);
3471: write_log('LOG','PAY_34014_IP_UPD_LEG_CURR',p_Legislation_Code,p_currency_code);
3472: update_shadow_tables(p_legislation_code, p_currency_code);
3473:

Line 3476: hr_utility.set_location('pay_ip_startup_util.setup',70);

3472: update_shadow_tables(p_legislation_code, p_currency_code);
3473:
3474: -- Inserting in to HR_S_HISTORY table
3475:
3476: hr_utility.set_location('pay_ip_startup_util.setup',70);
3477: write_log('LOG',NULL,NULL,NULL);
3478: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
3479: insert_history_table(p_legislation_code);
3480:

Line 3482: hr_utility.set_location('pay_ip_startup_util.setup',80);

3478: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
3479: insert_history_table(p_legislation_code);
3480:
3481: -- Moving to Main Tables
3482: hr_utility.set_location('pay_ip_startup_util.setup',80);
3483: write_log('LOG',NULL,NULL,NULL);
3484: write_log('LOG','PAY_34016_IP_CALL_PROC','HR_LEGISLATION.INSTALL',NULL);
3485: BEGIN
3486: move_to_main_tables;

Line 3497: hr_utility.set_location('pay_ip_startup_util.setup',90);

3493: create_report_format_param(p_legislation_code => p_legislation_code);
3494: write_log('LOG',NULL,NULL,NULL);
3495: write_log('LOG','PAY_34017_IP_UPD_TL_TABLE',NULL,NULL);
3496:
3497: hr_utility.set_location('pay_ip_startup_util.setup',90);
3498: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
3499: update_ele_class_tl(p_legislation_code);
3500:
3501: hr_utility.set_location('pay_ip_startup_util.setup',100);

Line 3501: hr_utility.set_location('pay_ip_startup_util.setup',100);

3497: hr_utility.set_location('pay_ip_startup_util.setup',90);
3498: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
3499: update_ele_class_tl(p_legislation_code);
3500:
3501: hr_utility.set_location('pay_ip_startup_util.setup',100);
3502: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
3503: update_bal_type_tl(p_legislation_code);
3504:
3505: --Run Types

Line 3506: hr_utility.set_location('pay_ip_startup_util.setup',110);

3502: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
3503: update_bal_type_tl(p_legislation_code);
3504:
3505: --Run Types
3506: hr_utility.set_location('pay_ip_startup_util.setup',110);
3507: create_runtype(p_legislation_code);
3508:
3509: hr_utility.set_location('pay_ip_startup_util.setup',120);
3510: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_RUN_TYPES_TL',NULL);

Line 3509: hr_utility.set_location('pay_ip_startup_util.setup',120);

3505: --Run Types
3506: hr_utility.set_location('pay_ip_startup_util.setup',110);
3507: create_runtype(p_legislation_code);
3508:
3509: hr_utility.set_location('pay_ip_startup_util.setup',120);
3510: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_RUN_TYPES_TL',NULL);
3511: update_run_type_tl(p_legislation_code);
3512:
3513: --Balance Categories

Line 3514: hr_utility.set_location('pay_ip_startup_util.setup',125);

3510: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_RUN_TYPES_TL',NULL);
3511: update_run_type_tl(p_legislation_code);
3512:
3513: --Balance Categories
3514: hr_utility.set_location('pay_ip_startup_util.setup',125);
3515: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_CATGORIES_F_TL',NULL);
3516: update_bal_categories_tl(p_legislation_code);
3517: -- Bug 4159036. Deliver Balance Attribute Definitions
3518:

Line 3520: hr_utility.set_location('pay_ip_startup_util.setup',130);

3516: update_bal_categories_tl(p_legislation_code);
3517: -- Bug 4159036. Deliver Balance Attribute Definitions
3518:
3519: -- Balance Attribute Definitions
3520: hr_utility.set_location('pay_ip_startup_util.setup',130);
3521:
3522: create_bal_att_def(p_legislation_code);
3523:
3524: -- Element Templates and other data needed for the legislation to use

Line 3527: hr_utility.set_location('pay_ip_startup_util.setup', 135);

3523:
3524: -- Element Templates and other data needed for the legislation to use
3525: -- Element Design Wizard(EDW)
3526:
3527: hr_utility.set_location('pay_ip_startup_util.setup', 135);
3528: write_log('LOG',NULL,NULL,NULL);
3529: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_CREATE_ELEMNT_TMPLT_RECORD.CREATE_ALL_TEMPLATES',NULL);
3530: pay_create_elemnt_tmplt_record.create_all_templates
3531: (p_legislation_code,p_currency_code);

Line 3535: hr_utility.set_location('pay_ip_startup_util.setup', 136);

3531: (p_legislation_code,p_currency_code);
3532:
3533: /*bug 10212578 Begin*/
3534: -- Retropay(Enhanced) support for International Localisation
3535: hr_utility.set_location('pay_ip_startup_util.setup', 136);
3536: write_log('LOG',NULL,NULL,NULL);
3537: write_log('LOG','PAY_34016_IP_CALL_PROC','CREATE_ENH_RETRO_SETUP',NULL);
3538: create_enh_retro_setup(p_legislation_code);
3539:

Line 3544: hr_utility.set_location('pay_ip_startup_util.setup', 138);

3540:
3541: /*bug 10212578 End*/
3542:
3543:
3544: hr_utility.set_location('pay_ip_startup_util.setup', 138);
3545: write_log('LOG',NULL,NULL,NULL);
3546: write_log('LOG','PAY_34016_IP_CALL_PROC','CREATE_GEN_UPG_DFN',NULL);
3547: create_gen_upg_dfn(p_legislation_code);
3548:

Line 3550: hr_utility.set_location('pay_ip_startup_util.setup', 140);

3546: write_log('LOG','PAY_34016_IP_CALL_PROC','CREATE_GEN_UPG_DFN',NULL);
3547: create_gen_upg_dfn(p_legislation_code);
3548:
3549: /* #13772336 added start*/
3550: hr_utility.set_location('pay_ip_startup_util.setup', 140);
3551: write_log('LOG',NULL,NULL,NULL);
3552: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_IP_UTILITY.INSERT_BAL_LOOKUP_VAL',NULL);
3553: pay_ip_utility.insert_bal_lookup_val(p_legislation_code);
3554: /* #13772336 added end*/

Line 3560: hr_utility.set_location('pay_ip_startup_util.setup', 150);

3556: /* Bug#14349456 : Creating a Menu Entry for the Self Service functions
3557: into the Menu HR__SS_FUNCTIONS_SEED
3558: to enable function level security.
3559: */
3560: hr_utility.set_location('pay_ip_startup_util.setup', 150);
3561: write_log('LOG',NULL,NULL,NULL);
3562: write_log('LOG','PAY_34016_IP_CALL_PROC','CREATE_FND_MENU_ENTRY',NULL);
3563: create_fnd_menu_entry(p_legislation_code,'PAY_IP_VIEW_EMPBAL_SS');
3564:

Line 3565: hr_utility.set_location('pay_ip_startup_util.setup', 160);

3561: write_log('LOG',NULL,NULL,NULL);
3562: write_log('LOG','PAY_34016_IP_CALL_PROC','CREATE_FND_MENU_ENTRY',NULL);
3563: create_fnd_menu_entry(p_legislation_code,'PAY_IP_VIEW_EMPBAL_SS');
3564:
3565: hr_utility.set_location('pay_ip_startup_util.setup', 160);
3566: write_log('LOG',NULL,NULL,NULL);
3567: write_log('LOG','PAY_34016_IP_CALL_PROC','FND_MENU_ENTRIES_PKG.SUBMIT_COMPILE',NULL);
3568: lv_request_status := fnd_menu_entries_pkg.submit_compile;
3569:

Line 3571: hr_utility.set_location('pay_ip_startup_util.setup', 170);

3567: write_log('LOG','PAY_34016_IP_CALL_PROC','FND_MENU_ENTRIES_PKG.SUBMIT_COMPILE',NULL);
3568: lv_request_status := fnd_menu_entries_pkg.submit_compile;
3569:
3570:
3571: hr_utility.set_location('pay_ip_startup_util.setup', 170);
3572: write_log('LOG',NULL,NULL,NULL);
3573: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_IP_UTILITY.COMPILE_FLEX_FIELD',NULL);
3574:
3575: pay_ip_utility.compile_flex_field(p_mode => 'DFF',

Line 3585: hr_utility.set_location('pay_ip_startup_util.setup', 180);

3581: p_application_short_name => 'PER',
3582: p_descriptive_flexfield_name => 'Org Developer DF');
3583:
3584: IF p_install_tax_unit = 'Y' THEN
3585: hr_utility.set_location('pay_ip_startup_util.setup', 180);
3586:
3587: pay_ip_utility.compile_flex_field(
3588: p_mode => 'KFF-STR',
3589: p_application_short_name => 'PER',

Line 3610: hr_utility.set_location('pay_ip_startup_util.setup', 190);

3606: ,p_appl_release => lv_appl_release
3607: ,p_leg_code => p_legislation_code)
3608: ) THEN
3609:
3610: hr_utility.set_location('pay_ip_startup_util.setup', 190);
3611: write_log('LOG',NULL,NULL,NULL);
3612: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_IP_UTILITY.INSERT_PATCH_STATUS',NULL);
3613: pay_ip_utility.insert_patch_status(
3614: p_patch_name => lv_patch_name,

Line 3636: hr_utility.set_location('pay_ip_startup_util.setup', 200);

3632:
3633: END IF;
3634: END IF;
3635:
3636: hr_utility.set_location('pay_ip_startup_util.setup', 200);
3637:
3638: p_retcode := 0;
3639:
3640: COMMIT;

Line 3645: hr_utility.set_location('pay_ip_startup_util.setup',140);

3641:
3642: write_log('OUTPUT',NULL,NULL,NULL);
3643: write_log('OUTPUT','PAY_34023_IP_LEG_INS_ENDS',NULL,NULL);
3644:
3645: hr_utility.set_location('pay_ip_startup_util.setup',140);
3646:
3647: ELSE
3648: p_retcode := 2;
3649: END IF;

Line 3651: hr_utility.set_location('pay_ip_startup_util.setup',150);

3647: ELSE
3648: p_retcode := 2;
3649: END IF;
3650:
3651: hr_utility.set_location('pay_ip_startup_util.setup',150);
3652:
3653: EXCEPTION
3654: WHEN OTHERS THEN
3655: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);