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

Line 40: hr_utility.set_location('pay_ip_startup_util.write_log',10);

36: p_token1 VARCHAR2,
37: p_token2 VARCHAR2) IS
38:
39: BEGIN
40: hr_utility.set_location('pay_ip_startup_util.write_log',10);
41: IF p_message IS NOT NULL THEN
42: fnd_message.set_name('PAY', p_message);
43:
44: IF p_token1 IS NOT NULL THEN

Line 67: hr_utility.set_location('pay_ip_startup_util.write_log',20);

63: ELSE
64: NULL;
65: END IF;
66: END IF;
67: hr_utility.set_location('pay_ip_startup_util.write_log',20);
68: END;
69:
70: -- ----------------------------------------------------------------
71: -- Procedure to write into output file.

Line 256: /*hr_utility.set_location('--pay_ip_startup_util.insert_ownership',10);

252: BEGIN
253:
254: null;
255:
256: /*hr_utility.set_location('--pay_ip_startup_util.insert_ownership',10);
257: INSERT INTO hr_s_application_ownerships
258: ( key_name
259: ,product_name
260: ,key_value)

Line 273: hr_utility.set_location('--pay_ip_startup_util.insert_ownership',20); */

269: AND key_name = p_key_name
270: AND key_value = p_key_value);
271:
272:
273: hr_utility.set_location('--pay_ip_startup_util.insert_ownership',20); */
274: END insert_ownership;
275: -- ---------------------------------------------------------------------
276: -- Function to check if
277: -- Localisation is available for the given legislation

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

288: l_Installed number := 0;
289: l_reference number := 0;
290:
291: BEGIN
292: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
293: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
294: --for the given legislation and if no other patch is getting applied
295: --and reference data is available.
296:

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

338: RETURN v_check_installation ;
339: END IF;
340:
341: RETURN v_check_installation ;
342: hr_utility.set_location('pay_ip_startup_util.check_to_install',20);
343: END check_to_install;
344:
345: -- ---------------------------------------------------------------------
346: -- Procedure to clear all HR_S tables

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

347: -- ---------------------------------------------------------------------
348: PROCEDURE clear_shadow_tables IS
349:
350: BEGIN
351: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',10);
352: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_FORMULA_TYPES',NULL);
353: DELETE hr_s_formula_types;
354: COMMIT;
355:

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

603:
604: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);
605: DELETE HR_S_STATE_RULES;
606: COMMIT;
607: hr_utility.set_location('pay_ip_startup_util.clear_shadow_table',20);
608: END clear_shadow_tables;
609:
610:
611: -- -----------------------------------------------------------------------

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

690:
691:
692:
693: BEGIN
694: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
695: --Legislation Rules
696: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
697:
698: INSERT INTO hr_s_application_ownerships

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

810: ----pay_ip_startup_util.insert_ownership('CLASSIFICATION_ID','PAY',rec.classification_id);
811:
812: END LOOP;
813:
814: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables',20);
815: --Balance Types
816: write_log('LOG',NULL,NULL,NULL);
817: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
818: FOR rec IN get_balance_type_csr LOOP

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

904: ----pay_ip_startup_util.insert_ownership('BALANCE_TYPE_ID','PER',rec.balance_type_id);
905: --pay_ip_startup_util.insert_ownership('BALANCE_TYPE_ID','PAY',rec.balance_type_id);
906: END LOOP;
907:
908: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',30);
909:
910: --Defined Balance
911: write_log('LOG',NULL,NULL,NULL);
912: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');

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

946: );
947:
948: END LOOP;
949:
950: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',40);
951:
952: --Balance Dimensions
953:
954: write_log('LOG',NULL,NULL,NULL);

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

997: write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Dimension', rec.dimension_name);
998:
999: END LOOP;
1000:
1001: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',50);
1002:
1003: --Routes
1004:
1005: write_log('LOG',NULL,NULL,NULL);

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

1050: END IF;
1051:
1052:
1053:
1054: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',60);
1055: -- Route Parameters
1056: write_log('LOG',NULL,NULL,NULL);
1057: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Parameters', 'HR_S_ROUTE_PARAMETERS');
1058: INSERT INTO hr_s_route_parameters

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

1077: WHERE EXISTS ( SELECT NULL
1078: FROM hr_s_routes b
1079: WHERE b.route_id = a.route_id));
1080:
1081: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',70);
1082:
1083: -- Used column to column mapping in the insert statement to remove
1084: -- error caused by mismatch in number of fields. Bug No 3720975.
1085:

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

1103: RULE_MODE
1104: FROM pay_legislative_field_info
1105: WHERE nvl(legislation_code,'X') = 'ZZ');
1106:
1107: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',80);
1108:
1109: --Balance Classifications
1110:
1111: write_log('LOG',NULL,NULL,NULL);

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

1147: write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Classifications', rec.balance_classification_id);
1148:
1149: END LOOP;
1150:
1151: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',90);
1152:
1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN

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

1219: INTO l_application_id
1220: FROM FND_APPLICATION
1221: WHERE application_short_name = p_appl_Short_Name;
1222:
1223: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1224: fnd_flex_key_api.set_session_mode('seed_data');
1225:
1226: l_flexfield := fnd_flex_key_api.find_flexfield
1227: ( appl_short_name => p_appl_short_name,

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

1226: l_flexfield := fnd_flex_key_api.find_flexfield
1227: ( appl_short_name => p_appl_short_name,
1228: flex_code => p_flex_code );
1229:
1230: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);
1231: BEGIN
1232:
1233: l_structure := fnd_flex_key_api.find_structure
1234: ( flexfield => l_flexfield,

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

1234: ( flexfield => l_flexfield,
1235: structure_code => p_structure_code );
1236:
1237: return l_structure.structure_number;
1238: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',30);
1239: EXCEPTION
1240: WHEN NO_DATA_FOUND THEN
1241:
1242: -- Bug 4544374. Check if the structure code exists with this title already.

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

1285: structure => l_structure );
1286:
1287: RETURN l_structure.structure_number;
1288: END;
1289: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',40);
1290: END create_key_flexfield;
1291:
1292: -- ---------------------------------------------------------------------
1293: -- Procedure for creating the Flex field segments

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

1317: l_flex_num NUMBER(15);
1318: l_segment fnd_flex_key_api.segment_type;
1319: BEGIN
1320:
1321: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1322: fnd_flex_key_api.set_session_mode('seed_data');
1323: l_flexfield := fnd_flex_key_api.find_flexfield
1324: ( appl_short_name => p_appl_short_name,
1325: flex_code => p_flex_code );

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

1323: l_flexfield := fnd_flex_key_api.find_flexfield
1324: ( appl_short_name => p_appl_short_name,
1325: flex_code => p_flex_code );
1326:
1327: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);
1328:
1329: l_structure := fnd_flex_key_api.find_structure
1330: ( flexfield => l_flexfield,
1331: structure_code => p_structure_code );

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

1329: l_structure := fnd_flex_key_api.find_structure
1330: ( flexfield => l_flexfield,
1331: structure_code => p_structure_code );
1332:
1333: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1334: begin
1335:
1336: hr_utility.trace(p_segment_name);
1337: l_segment := fnd_flex_key_api.find_segment

Line 1336: hr_utility.trace(p_segment_name);

1332:
1333: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1334: begin
1335:
1336: hr_utility.trace(p_segment_name);
1337: l_segment := fnd_flex_key_api.find_segment
1338: (
1339: flexfield => l_flexfield
1340: ,structure => l_structure

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

1364: ,lov_prompt => p_lov_prompt
1365: ,window_prompt => p_window_prompt
1366: );
1367:
1368: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1369:
1370: hr_utility.trace(p_segment_name);
1371: begin
1372: fnd_flex_key_api.add_segment

Line 1370: hr_utility.trace(p_segment_name);

1366: );
1367:
1368: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1369:
1370: hr_utility.trace(p_segment_name);
1371: begin
1372: fnd_flex_key_api.add_segment
1373: (
1374: flexfield => l_flexfield

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

1376: ,segment => l_segment
1377: );
1378: exception
1379: when others then
1380: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1381: end;
1382: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1383: fnd_flex_key_api.assign_qualifier
1384: (

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

1378: exception
1379: when others then
1380: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1381: end;
1382: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1383: fnd_flex_key_api.assign_qualifier
1384: (
1385: flexfield => l_flexfield
1386: ,structure => l_structure

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

1401: p_Rule_Type IN VARCHAR2,
1402: p_Rule_mode IN VARCHAR2) IS
1403:
1404: BEGIN
1405: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',10);
1406:
1407: INSERT INTO hr_s_legislation_rules
1408: ( legislation_code
1409: ,rule_type

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

1422: rule_mode = p_rule_mode
1423: WHERE legislation_code = 'ZZ'
1424: AND rule_type = p_rule_type;
1425: END IF;
1426: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',20);
1427: END;
1428:
1429: -- ---------------------------------------------------------------------
1430: -- HR_S Tables are updated to the choosen legislation_code and currency

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

1433: (p_legislation_code IN VARCHAR2,
1434: p_currency_code IN VARCHAR2) IS
1435:
1436: BEGIN
1437: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1438: --Updating Element Classifications Table
1439:
1440: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1441: UPDATE hr_s_element_classifications

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

1485: UPDATE hr_s_balance_classifications
1486: SET legislation_code = p_legislation_code
1487: WHERE legislation_code = 'ZZ';
1488:
1489: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',20);
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

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

1501: PROCEDURE insert_history_table
1502: (p_legislation_code IN VARCHAR2) IS
1503:
1504: BEGIN
1505: hr_utility.set_location('pay_ip_startup_util.insert_history_table',10);
1506: INSERT INTO hr_s_history
1507: ( package_name
1508: ,date_of_export
1509: ,date_of_import

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

1514: ,sysdate
1515: ,sysdate
1516: ,'HR_S tabes copied from reference account'
1517: ,p_legislation_code);
1518: hr_utility.set_location('pay_ip_startup_util.insert_history_table',20);
1519: END insert_history_table ;
1520:
1521: -- ---------------------------------------------------------------------
1522: -- The data from Shadow tables are moved in to the main tables with the

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

1524: -- ---------------------------------------------------------------------
1525: PROCEDURE move_to_main_tables IS
1526:
1527: BEGIN
1528: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',10);
1529: hr_legislation.install;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

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

1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
1534:
1535: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',20);
1536: END move_to_main_tables;
1537:
1538: -- ---------------------------------------------------------------------
1539: -- Procedure to update the TL tables with the translated values.

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

1565: rec_tltable_csr get_classid_tltable_csr%ROWTYPE;
1566:
1567: BEGIN
1568:
1569: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',10);
1570:
1571: FOR l_record in get_classid_btable_csr LOOP
1572:
1573: OPEN get_classid_tltable_csr(p_legislation_code, l_record.bname, l_record.language);

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

1596: IF get_classid_tltable_csr%ISOPEN THEN
1597: CLOSE get_classid_tltable_csr;
1598: END IF;
1599: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
1600: hr_utility.set_location('pay_ip_startup_util.update_ele_class_tl',20);
1601: END update_ele_class_tl;
1602:
1603: -- Updating Balance Types TL Table
1604:

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

1626:
1627: rec_tltable_csr get_balid_tltable_csr%ROWTYPE;
1628:
1629: BEGIN
1630: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',10);
1631:
1632: FOR l_record in get_balid_btable_csr LOOP
1633:
1634: OPEN get_balid_tltable_csr(p_legislation_code, l_record.bname, l_record.language);

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

1659: END IF;
1660:
1661: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
1662:
1663: hr_utility.set_location('pay_ip_startup_util.update_bal_type_tl',20);
1664:
1665: END update_bal_type_tl;
1666:
1667: PROCEDURE create_runtype

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

1745:
1746: BEGIN
1747: -- Run Types
1748:
1749: hr_utility.set_location('pay_ip_startup_util.create_runtype',10);
1750:
1751: write_log('LOG',NULL,NULL,NULL);
1752: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_RUN_TYPE_API',NULL);
1753:

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

1788: END LOOP;
1789:
1790: -- Run Type Usages
1791:
1792: hr_utility.set_location('pay_ip_startup_util.create_runtype',20);
1793:
1794: write_log('LOG',NULL,NULL,NULL);
1795: write_log('LOG','PAY_34016_IP_CALL_PROC','PAY_RUN_TYPE_USAGE_API',NULL);
1796:

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

1840:
1841: END LOOP; --child
1842: END LOOP; --parent
1843:
1844: hr_utility.set_location('pay_ip_startup_util.create_runtype',30);
1845:
1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: IF run_type_csr%ISOPEN THEN

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

1874: AND business_group_id IS NULL;
1875: --
1876: BEGIN
1877: --
1878: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',10);
1879:
1880: write_log('LOG',NULL,NULL,NULL);
1881: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Attribute Definitions', 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
1882:

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

1895: );
1896:
1897: END LOOP;
1898:
1899: hr_utility.set_location('pay_ip_startup_util.create_bal_att_def',20);
1900: --
1901: EXCEPTION
1902: when others then
1903: if get_bal_att_def%isopen then

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

1935: rec_tltable_csr get_runid_tltable_csr%ROWTYPE;
1936:
1937: BEGIN
1938:
1939: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',10);
1940:
1941: FOR l_record in get_runid_btable_csr LOOP
1942:
1943: OPEN get_runid_tltable_csr(p_legislation_code, l_record.bname, l_record.language) ;

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

1957: CLOSE get_runid_tltable_csr;
1958:
1959: END LOOP;
1960:
1961: hr_utility.set_location('pay_ip_startup_util.update_run_type_tl',20);
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF get_runid_btable_csr%ISOPEN THEN
1965: CLOSE get_runid_btable_csr;

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

2005: and id_flex_num = p_id_flex_num;
2006:
2007: BEGIN
2008:
2009: hr_utility.set_location('pay_ip_startup_util.setup',10);
2010: IF check_to_install(p_legislation_code) THEN
2011:
2012: -- Check if logging of message is required.
2013: g_logging := logging(p_action_parameter_group_id);

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

2019:
2020:
2021: --Clearing all HRMS HR_S tables
2022: write_log('OUTPUT','PAY_34022_IP_LEG_INS_BEGINS', l_territory_with_code ,to_char(sysdate,'dd-Mon-yyyy hh:mi:ss'));
2023: hr_utility.set_location('pay_ip_startup_util.setup',20);
2024: write_log('LOG',NULL,NULL,NULL);
2025: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S%',NULL);
2026: clear_shadow_tables;
2027:

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

2026: clear_shadow_tables;
2027:
2028: --Moving data to shadow table
2029:
2030: hr_utility.set_location('pay_ip_startup_util.setup',30);
2031: write_log('LOG',NULL,NULL,NULL);
2032: write_log('LOG','PAY_34009_IP_MOVE_TO_HR_S',NULL,NULL);
2033: move_to_shadow_tables(p_legislation_code, p_install_tax_unit);
2034:

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

2108: create_leg_rule(p_legislation_code => p_legislation_code,
2109: p_rule_type => 'TAX_UNIT',
2110: p_rule_mode => 'Y');
2111:
2112: hr_utility.set_location('pay_ip_startup_util.setup',40);
2113: write_log('LOG',NULL,NULL,NULL);
2114: write_log('LOG','PAY_34007_IP_CREATE_FLEX',p_Legislation_Code ||
2115: '_STATUTORY_INFO', NULL);
2116:

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

2193: p_lov_prompt => 'Tax Unit',
2194: p_window_prompt => 'Tax Unit');
2195: END IF;
2196:
2197: hr_utility.set_location('pay_ip_startup_util.setup',50);
2198: END IF;
2199:
2200: --Create FlexField
2201:

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

2198: END IF;
2199:
2200: --Create FlexField
2201:
2202: hr_utility.set_location('pay_ip_startup_util.setup',40);
2203: write_log('LOG',NULL,NULL,NULL);
2204: write_log('LOG','PAY_34007_IP_CREATE_FLEX',p_Legislation_Code || '_BANK_DETAILS', NULL);
2205: l_id_flex_num := create_key_flexfield
2206: (p_appl_short_name => 'PAY',

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

2217: p_shorthand_enabled_flag => 'N',
2218: p_shorthand_prompt => '',
2219: p_shorthand_length => 10);
2220:
2221: hr_utility.set_location('pay_ip_startup_util.setup',50);
2222: write_log('LOG','PAY_34008_IP_INS_LEG_RULE',p_Legislation_Code || '_BANK_DETAILS', NULL);
2223: create_leg_rule
2224: (p_legislation_code => p_legislation_code,
2225: p_rule_type => 'E',

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

2228: write_out;
2229:
2230: --Updating shadow table
2231:
2232: hr_utility.set_location('pay_ip_startup_util.setup',60);
2233: write_log('LOG',NULL,NULL,NULL);
2234: write_log('LOG','PAY_34014_IP_UPD_LEG_CURR',p_Legislation_Code,p_currency_code);
2235: update_shadow_tables(p_legislation_code, p_currency_code);
2236:

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

2235: update_shadow_tables(p_legislation_code, p_currency_code);
2236:
2237: -- Inserting in to HR_S_HISTORY table
2238:
2239: hr_utility.set_location('pay_ip_startup_util.setup',70);
2240: write_log('LOG',NULL,NULL,NULL);
2241: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
2242: insert_history_table(p_legislation_code);
2243:

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

2241: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
2242: insert_history_table(p_legislation_code);
2243:
2244: -- Moving to Main Tables
2245: hr_utility.set_location('pay_ip_startup_util.setup',80);
2246: write_log('LOG',NULL,NULL,NULL);
2247: write_log('LOG','PAY_34016_IP_CALL_PROC','HR_LEGISLATION.INSTALL',NULL);
2248: BEGIN
2249: move_to_main_tables;

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

2256:
2257: write_log('LOG',NULL,NULL,NULL);
2258: write_log('LOG','PAY_34017_IP_UPD_TL_TABLE',NULL,NULL);
2259:
2260: hr_utility.set_location('pay_ip_startup_util.setup',90);
2261: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
2262: update_ele_class_tl(p_legislation_code);
2263:
2264: hr_utility.set_location('pay_ip_startup_util.setup',100);

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

2260: hr_utility.set_location('pay_ip_startup_util.setup',90);
2261: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
2262: update_ele_class_tl(p_legislation_code);
2263:
2264: hr_utility.set_location('pay_ip_startup_util.setup',100);
2265: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
2266: update_bal_type_tl(p_legislation_code);
2267:
2268: --Run Types

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

2265: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
2266: update_bal_type_tl(p_legislation_code);
2267:
2268: --Run Types
2269: hr_utility.set_location('pay_ip_startup_util.setup',110);
2270: create_runtype(p_legislation_code);
2271:
2272: hr_utility.set_location('pay_ip_startup_util.setup',120);
2273: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_RUN_TYPES_TL',NULL);

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

2268: --Run Types
2269: hr_utility.set_location('pay_ip_startup_util.setup',110);
2270: create_runtype(p_legislation_code);
2271:
2272: hr_utility.set_location('pay_ip_startup_util.setup',120);
2273: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_RUN_TYPES_TL',NULL);
2274: update_run_type_tl(p_legislation_code);
2275:
2276: -- Bug 4159036. Deliver Balance Attribute Definitions

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

2275:
2276: -- Bug 4159036. Deliver Balance Attribute Definitions
2277:
2278: -- Balance Attribute Definitions
2279: hr_utility.set_location('pay_ip_startup_util.setup',130);
2280: create_bal_att_def(p_legislation_code);
2281:
2282: -- Element Templates and other data needed for the legislation to use
2283: -- Element Design Wizard(EDW)

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

2281:
2282: -- Element Templates and other data needed for the legislation to use
2283: -- Element Design Wizard(EDW)
2284:
2285: hr_utility.set_location('pay_ip_startup_util.setup', 135);
2286: pay_create_elemnt_tmplt_record.create_all_templates
2287: (p_legislation_code,p_currency_code);
2288:
2289: p_retcode := 0;

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

2292:
2293: write_log('OUTPUT',NULL,NULL,NULL);
2294: write_log('OUTPUT','PAY_34023_IP_LEG_INS_ENDS',NULL,NULL);
2295:
2296: hr_utility.set_location('pay_ip_startup_util.setup',140);
2297:
2298: ELSE
2299: p_retcode := 2;
2300: END IF;

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

2298: ELSE
2299: p_retcode := 2;
2300: END IF;
2301:
2302: hr_utility.set_location('pay_ip_startup_util.setup',150);
2303:
2304: EXCEPTION
2305: WHEN OTHERS THEN
2306: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);