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.HR_LOCATION_API dependencies on HR_UTILITY

Line 116: hr_utility.set_location('Entering:'|| l_proc, 10);

112: l_inactive_date DATE;
113: --
114: BEGIN
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Issue a savepoint
119: --
120: savepoint create_location;

Line 122: hr_utility.set_location(l_proc, 15);

118: -- Issue a savepoint
119: --
120: savepoint create_location;
121: --
122: hr_utility.set_location(l_proc, 15);
123: --
124: -- All date input parameters must be truncated to remove time elements
125: --
126: l_inactive_date := trunc (p_inactive_date);

Line 136: hr_utility.set_location(l_proc, 20);

132: --
133: l_language_code := p_language_code;
134: hr_api.validate_language_code(p_language_code => l_language_code);
135: --
136: hr_utility.set_location(l_proc, 20);
137: --
138: BEGIN
139: --
140: -- Start of API User Hook for the before hook of create_location

Line 241: hr_utility.set_location(l_proc, 25);

237: -- Process Logic
238: --
239: -- Insert non-translatable rows into HR_LOCATIONS_ALL first
240:
241: hr_utility.set_location(l_proc, 25);
242:
243: hr_location_internal.create_generic_location
244: ( p_effective_date => p_effective_date
245: ,p_location_id => l_location_id

Line 435: hr_utility.set_location(l_proc, 60);

431: --
432: -- End of API User Hook for the after hook of create_location
433: --
434: END;
435: hr_utility.set_location(l_proc, 60);
436: --
437: -- When in validation only mode raise the Validate_Enabled exception
438: --
439: IF p_validate THEN

Line 462: hr_utility.set_location(' Leaving:'||l_proc, 80);

458: -- when validation only mode is being used.)
459: --
460: p_location_id := NULL;
461: p_object_version_number := NULL;
462: hr_utility.set_location(' Leaving:'||l_proc, 80);
463: WHEN OTHERS THEN
464: --
465: -- A validation or unexpected error has occurred
466: ROLLBACK TO create_location;

Line 470: hr_utility.set_location(' Leaving:'||l_proc, 90);

466: ROLLBACK TO create_location;
467: -- Set OUT parameters.
468: p_location_id := NULL;
469: p_object_version_number := NULL;
470: hr_utility.set_location(' Leaving:'||l_proc, 90);
471: RAISE;
472: --
473: END create_location;
474: -- ----------------------------------------------------------------------------

Line 587: hr_utility.set_location('Entering:'|| l_proc, 10);

583: l_town_or_city VARCHAR2(30);
584:
585: BEGIN
586: --
587: hr_utility.set_location('Entering:'|| l_proc, 10);
588: --
589: -- Issue a savepoint.
590: --
591: savepoint update_location;

Line 605: hr_utility.set_location(l_proc, 20);

601: -- passed through.
602: --
603: l_language_code := p_language_code;
604: hr_api.validate_language_code(p_language_code => l_language_code);
605: hr_utility.set_location(l_proc, 20);
606:
607: if hr_general2.is_location_legal_adr(p_location_id => p_location_id) then
608: --
609: -- fix for bug 9223716,the address fields are enabled for update.

Line 653: hr_utility.set_location(l_proc, 25);

649: from hr_locations_all loc
650: where loc.location_id = p_location_id;
651: -- fix 3219077 end
652:
653: hr_utility.set_location(l_proc, 25);
654:
655: if (
656:
657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>

Line 682: hr_utility.set_location(l_proc, 26);

678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */
680: ) then
681:
682: hr_utility.set_location(l_proc, 26);
683:
684: hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');
685: hr_utility.raise_error;
686:

Line 684: hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');

680: ) then
681:
682: hr_utility.set_location(l_proc, 26);
683:
684: hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');
685: hr_utility.raise_error;
686:
687: end if;
688:

Line 685: hr_utility.raise_error;

681:
682: hr_utility.set_location(l_proc, 26);
683:
684: hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');
685: hr_utility.raise_error;
686:
687: end if;
688:
689: end if;

Line 989: hr_utility.set_location(l_proc, 60);

985: -- End of API User Hook for the after hook of update_location
986: --
987: END;
988: --
989: hr_utility.set_location(l_proc, 60);
990: --
991: -- When in validation only mode raise the Validate_Enabled exception
992: --
993: IF p_validate THEN

Line 1002: hr_utility.set_location(' Leaving:'||l_proc, 70);

998: -- never reached, so p_object_version_number is passed back unchanged.
999: --
1000: p_object_version_number := l_object_version_number;
1001: --
1002: hr_utility.set_location(' Leaving:'||l_proc, 70);
1003: --
1004: EXCEPTION
1005: --
1006: WHEN hr_api.validate_enabled THEN

Line 1018: hr_utility.set_location(' Leaving:'||l_proc, 80);

1014: -- (Any key or derived arguments must be set to null
1015: -- when validation only mode is being used.)
1016: -- Reset IN OUT parameters.
1017: p_object_version_number := l_temp_ovn;
1018: hr_utility.set_location(' Leaving:'||l_proc, 80);
1019: WHEN OTHERS THEN
1020: --
1021: -- A validation or unexpected error has occurred
1022: ROLLBACK TO update_location;

Line 1025: hr_utility.set_location(' Leaving:'||l_proc, 90);

1021: -- A validation or unexpected error has occurred
1022: ROLLBACK TO update_location;
1023: -- Reset IN OUT parameters.
1024: p_object_version_number := l_temp_ovn;
1025: hr_utility.set_location(' Leaving:'||l_proc, 90);
1026: RAISE;
1027: --
1028: --
1029: END update_location;

Line 1048: hr_utility.set_location('Entering:'|| l_proc, 10);

1044: l_proc VARCHAR2(72) := g_package||'delete_location';
1045: --
1046: BEGIN
1047: --
1048: hr_utility.set_location('Entering:'|| l_proc, 10);
1049: --
1050: -- Issue a savepoint
1051: --
1052: savepoint delete_location;

Line 1055: hr_utility.set_location( l_proc, 20);

1051: --
1052: savepoint delete_location;
1053: --
1054: BEGIN
1055: hr_utility.set_location( l_proc, 20);
1056: hr_location_bk3.delete_location_b (
1057: p_location_id => p_location_id,
1058: p_object_version_number => p_object_version_number );
1059: --

Line 1073: hr_utility.set_location( l_proc, 30);

1069: -- =============
1070: --
1071: -- Need to lock main table to maintain the locking ladder order
1072: --
1073: hr_utility.set_location( l_proc, 30);
1074: hr_loc_shd.lck ( p_location_id => p_location_id,
1075: p_object_version_number => p_object_version_number );
1076: --
1077: -- Remove all matching translation rows

Line 1079: hr_utility.set_location( l_proc, 35);

1075: p_object_version_number => p_object_version_number );
1076: --
1077: -- Remove all matching translation rows
1078: --
1079: hr_utility.set_location( l_proc, 35);
1080: hr_lot_del.del_tl (
1081: p_location_id => p_location_id );
1082: --
1083: -- Remove non-translated data row

Line 1085: hr_utility.set_location( l_proc, 40);

1081: p_location_id => p_location_id );
1082: --
1083: -- Remove non-translated data row
1084: --
1085: hr_utility.set_location( l_proc, 40);
1086: hr_loc_del.del(
1087: p_location_id => p_location_id,
1088: p_object_version_number => p_object_version_number );
1089: --

Line 1091: hr_utility.set_location( l_proc, 50);

1087: p_location_id => p_location_id,
1088: p_object_version_number => p_object_version_number );
1089: --
1090: BEGIN
1091: hr_utility.set_location( l_proc, 50);
1092: hr_location_bk3.delete_location_a (
1093: p_location_id => p_location_id,
1094: p_object_version_number => p_object_version_number );
1095: --

Line 1105: hr_utility.set_location(' Leaving:'||l_proc, 60);

1101: );
1102: END;
1103: --
1104: --
1105: hr_utility.set_location(' Leaving:'||l_proc, 60);
1106: --
1107: -- When in validation only mode raise the Validate_Enabled exception
1108: --
1109: IF p_validate THEN

Line 1127: hr_utility.set_location(' Leaving:'||l_proc, 80);

1123: -- Only set output warning arguments
1124: -- (Any key or derived arguments must be set to null
1125: -- when validation only mode is being used.)
1126: --
1127: hr_utility.set_location(' Leaving:'||l_proc, 80);
1128: WHEN OTHERS THEN
1129: --
1130: -- A validation or unexpected error has occurred
1131: ROLLBACK TO delete_location;

Line 1132: hr_utility.set_location(' Leaving:'||l_proc, 90);

1128: WHEN OTHERS THEN
1129: --
1130: -- A validation or unexpected error has occurred
1131: ROLLBACK TO delete_location;
1132: hr_utility.set_location(' Leaving:'||l_proc, 90);
1133: RAISE;
1134: --
1135: END delete_location;
1136: --

Line 1211: hr_utility.set_location('Entering:'|| l_proc, 10);

1207: l_inactive_date DATE;
1208: --
1209: BEGIN
1210: --
1211: hr_utility.set_location('Entering:'|| l_proc, 10);
1212: --
1213: -- Issue a savepoint
1214: --
1215: savepoint create_location_legal_adr;

Line 1217: hr_utility.set_location(l_proc, 15);

1213: -- Issue a savepoint
1214: --
1215: savepoint create_location_legal_adr;
1216: --
1217: hr_utility.set_location(l_proc, 15);
1218: --
1219: -- All date input parameters must be truncated to remove time elements
1220: --
1221: l_inactive_date := trunc (p_inactive_date);

Line 1231: hr_utility.set_location(l_proc, 20);

1227: --
1228: l_language_code := p_language_code;
1229: hr_api.validate_language_code(p_language_code => l_language_code);
1230: --
1231: hr_utility.set_location(l_proc, 20);
1232: --
1233:
1234: BEGIN
1235: --

Line 1433: hr_utility.set_location(l_proc, 60);

1429: -- End of API User Hook for the after hook of create_generic_location
1430: --
1431: END;
1432:
1433: hr_utility.set_location(l_proc, 60);
1434: --
1435: -- When in validation only mode raise the Validate_Enabled exception
1436: --
1437: IF p_validate THEN

Line 1460: hr_utility.set_location(' Leaving:'||l_proc, 80);

1456: -- when validation only mode is being used.)
1457: --
1458: p_location_id := NULL;
1459: p_object_version_number := NULL;
1460: hr_utility.set_location(' Leaving:'||l_proc, 80);
1461: WHEN OTHERS THEN
1462: --
1463: -- A validation or unexpected error has occurred
1464: ROLLBACK TO create_location_legal_adr;

Line 1468: hr_utility.set_location(' Leaving:'||l_proc, 90);

1464: ROLLBACK TO create_location_legal_adr;
1465: -- Set OUT parameters.
1466: p_location_id := NULL;
1467: p_object_version_number := NULL;
1468: hr_utility.set_location(' Leaving:'||l_proc, 90);
1469: RAISE;
1470: --
1471: END create_location_legal_adr;
1472: -- ----------------------------------------------------------------------------

Line 1537: hr_utility.set_location('Entering:'|| l_proc, 10);

1533: l_temp_ovn number(9) := p_object_version_number;
1534: --
1535: BEGIN
1536: --
1537: hr_utility.set_location('Entering:'|| l_proc, 10);
1538: --
1539: -- Issue a savepoint.
1540: --
1541: savepoint update_location_legal_adr;

Line 1735: hr_utility.set_location(l_proc, 60);

1731: -- End of API User Hook for the after hook of update_location_legal_adr
1732: --
1733: END;
1734: --
1735: hr_utility.set_location(l_proc, 60);
1736: --
1737: -- When in validation only mode raise the Validate_Enabled exception
1738: --
1739: IF p_validate THEN

Line 1748: hr_utility.set_location(' Leaving:'||l_proc, 70);

1744: -- never reached, so p_object_version_number is passed back unchanged.
1745: --
1746: p_object_version_number := l_object_version_number;
1747: --
1748: hr_utility.set_location(' Leaving:'||l_proc, 70);
1749: --
1750: EXCEPTION
1751: --
1752: WHEN hr_api.validate_enabled THEN

Line 1764: hr_utility.set_location(' Leaving:'||l_proc, 80);

1760: -- (Any key or derived arguments must be set to null
1761: -- when validation only mode is being used.)
1762: -- Reset IN OUT parameters.
1763: p_object_version_number := l_temp_ovn;
1764: hr_utility.set_location(' Leaving:'||l_proc, 80);
1765: WHEN OTHERS THEN
1766: --
1767: -- A validation or unexpected error has occurred
1768: ROLLBACK TO update_location_legal_adr;

Line 1771: hr_utility.set_location(' Leaving:'||l_proc, 90);

1767: -- A validation or unexpected error has occurred
1768: ROLLBACK TO update_location_legal_adr;
1769: -- Reset IN OUT parameters.
1770: p_object_version_number := l_temp_ovn;
1771: hr_utility.set_location(' Leaving:'||l_proc, 90);
1772: RAISE;
1773: --
1774: --
1775: END update_location_legal_adr;

Line 1803: hr_utility.set_location('Entering:'|| l_proc, 10);

1799: l_temp_ovn number := p_object_version_number;
1800: --
1801: BEGIN
1802: --
1803: hr_utility.set_location('Entering:'|| l_proc, 10);
1804: --
1805: -- Issue a savepoint
1806: --
1807: savepoint disable_location_legal_adr;

Line 1809: hr_utility.set_location(l_proc, 20);

1805: -- Issue a savepoint
1806: --
1807: savepoint disable_location_legal_adr;
1808: --
1809: hr_utility.set_location(l_proc, 20);
1810: --
1811: -- Process Logic
1812: --
1813: l_object_version_number := p_object_version_number;

Line 1850: hr_utility.set_location(l_proc, 60);

1846: ,p_legal_address_flag => NULL
1847: );
1848:
1849: --
1850: hr_utility.set_location(l_proc, 60);
1851: --
1852: -- Bug fix 3205662.
1853: -- User hook call added.
1854: --

Line 1887: hr_utility.set_location(' Leaving:'||l_proc, 70);

1883: -- never reached, so p_object_version_number is passed back unchanged.
1884: --
1885: p_object_version_number := l_object_version_number;
1886: --
1887: hr_utility.set_location(' Leaving:'||l_proc, 70);
1888: EXCEPTION
1889: --
1890: WHEN hr_api.validate_enabled THEN
1891: --

Line 1902: hr_utility.set_location(' Leaving:'||l_proc, 80);

1898: -- (Any key or derived arguments must be set to null
1899: -- when validation only mode is being used.)
1900: -- Reset IN OUT parameters.
1901: p_object_version_number := l_temp_ovn;
1902: hr_utility.set_location(' Leaving:'||l_proc, 80);
1903: WHEN OTHERS THEN
1904: --
1905: -- A validation or unexpected error has occurred
1906: ROLLBACK TO disable_location_legal_adr;

Line 1909: hr_utility.set_location(' Leaving:'||l_proc, 90);

1905: -- A validation or unexpected error has occurred
1906: ROLLBACK TO disable_location_legal_adr;
1907: -- Reset IN OUT parameters.
1908: p_object_version_number := l_temp_ovn;
1909: hr_utility.set_location(' Leaving:'||l_proc, 90);
1910: RAISE;
1911: --
1912: END disable_location_legal_adr;
1913: --

Line 1933: hr_utility.set_location('Entering:'|| l_proc, 10);

1929: l_temp_ovn number := p_object_version_number;
1930: --
1931: BEGIN
1932: --
1933: hr_utility.set_location('Entering:'|| l_proc, 10);
1934: --
1935: -- Issue a savepoint
1936: --
1937: savepoint enable_location_legal_adr;

Line 1939: hr_utility.set_location(l_proc, 20);

1935: -- Issue a savepoint
1936: --
1937: savepoint enable_location_legal_adr;
1938: --
1939: hr_utility.set_location(l_proc, 20);
1940: --
1941: -- Process Logic
1942: --
1943: l_object_version_number := p_object_version_number;

Line 1980: hr_utility.set_location(l_proc, 60);

1976: ,p_legal_address_flag => 'Y'
1977: );
1978:
1979: --
1980: hr_utility.set_location(l_proc, 60);
1981: --
1982: -- Bug fix 3205662.
1983: -- User hook call added.
1984: --

Line 2016: hr_utility.set_location(' Leaving:'||l_proc, 70);

2012: -- never reached, so p_object_version_number is passed back unchanged.
2013: --
2014: p_object_version_number := l_object_version_number;
2015: --
2016: hr_utility.set_location(' Leaving:'||l_proc, 70);
2017: EXCEPTION
2018: --
2019: WHEN hr_api.validate_enabled THEN
2020: --

Line 2031: hr_utility.set_location(' Leaving:'||l_proc, 80);

2027: -- (Any key or derived arguments must be set to null
2028: -- when validation only mode is being used.)
2029: -- Reset IN OUT parameters.
2030: p_object_version_number := l_temp_ovn;
2031: hr_utility.set_location(' Leaving:'||l_proc, 80);
2032: WHEN OTHERS THEN
2033: --
2034: -- A validation or unexpected error has occurred
2035: ROLLBACK TO enable_location_legal_adr;

Line 2038: hr_utility.set_location(' Leaving:'||l_proc, 90);

2034: -- A validation or unexpected error has occurred
2035: ROLLBACK TO enable_location_legal_adr;
2036: -- Reset IN OUT parameters.
2037: p_object_version_number := l_temp_ovn;
2038: hr_utility.set_location(' Leaving:'||l_proc, 90);
2039: RAISE;
2040: --
2041: END enable_location_legal_adr;
2042: --