eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.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 434: hr_utility.set_location(l_proc, 60);

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

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

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

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

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

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

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

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

600: -- passed through.
601: --
602: l_language_code := p_language_code;
603: hr_api.validate_language_code(p_language_code => l_language_code);
604: hr_utility.set_location(l_proc, 20);
605:
606: if hr_general2.is_location_legal_adr(p_location_id => p_location_id) then
607: --
608: --

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

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

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

676: nvl(l_town_or_city,hr_api.g_varchar2)
677: )
678: then
679:
680: hr_utility.set_location(l_proc, 26);
681:
682: hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');
683: hr_utility.raise_error;
684:

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

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

Line 683: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1191: l_inactive_date DATE;
1192: --
1193: BEGIN
1194: --
1195: hr_utility.set_location('Entering:'|| l_proc, 10);
1196: --
1197: -- Issue a savepoint
1198: --
1199: savepoint create_location_legal_adr;

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

1197: -- Issue a savepoint
1198: --
1199: savepoint create_location_legal_adr;
1200: --
1201: hr_utility.set_location(l_proc, 15);
1202: --
1203: -- All date input parameters must be truncated to remove time elements
1204: --
1205: l_inactive_date := trunc (p_inactive_date);

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

1211: --
1212: l_language_code := p_language_code;
1213: hr_api.validate_language_code(p_language_code => l_language_code);
1214: --
1215: hr_utility.set_location(l_proc, 20);
1216: --
1217:
1218: BEGIN
1219: --

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

1374: -- End of API User Hook for the after hook of create_generic_location
1375: --
1376: END;
1377:
1378: hr_utility.set_location(l_proc, 60);
1379: --
1380: -- When in validation only mode raise the Validate_Enabled exception
1381: --
1382: IF p_validate THEN

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

1401: -- when validation only mode is being used.)
1402: --
1403: p_location_id := NULL;
1404: p_object_version_number := NULL;
1405: hr_utility.set_location(' Leaving:'||l_proc, 80);
1406: WHEN OTHERS THEN
1407: --
1408: -- A validation or unexpected error has occurred
1409: ROLLBACK TO create_location_legal_adr;

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

1409: ROLLBACK TO create_location_legal_adr;
1410: -- Set OUT parameters.
1411: p_location_id := NULL;
1412: p_object_version_number := NULL;
1413: hr_utility.set_location(' Leaving:'||l_proc, 90);
1414: RAISE;
1415: --
1416: END create_location_legal_adr;
1417: -- ----------------------------------------------------------------------------

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

1465: l_temp_ovn number(9) := p_object_version_number;
1466: --
1467: BEGIN
1468: --
1469: hr_utility.set_location('Entering:'|| l_proc, 10);
1470: --
1471: -- Issue a savepoint.
1472: --
1473: savepoint update_location_legal_adr;

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

1624: -- End of API User Hook for the after hook of update_location_legal_adr
1625: --
1626: END;
1627: --
1628: hr_utility.set_location(l_proc, 60);
1629: --
1630: -- When in validation only mode raise the Validate_Enabled exception
1631: --
1632: IF p_validate THEN

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

1637: -- never reached, so p_object_version_number is passed back unchanged.
1638: --
1639: p_object_version_number := l_object_version_number;
1640: --
1641: hr_utility.set_location(' Leaving:'||l_proc, 70);
1642: --
1643: EXCEPTION
1644: --
1645: WHEN hr_api.validate_enabled THEN

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

1653: -- (Any key or derived arguments must be set to null
1654: -- when validation only mode is being used.)
1655: -- Reset IN OUT parameters.
1656: p_object_version_number := l_temp_ovn;
1657: hr_utility.set_location(' Leaving:'||l_proc, 80);
1658: WHEN OTHERS THEN
1659: --
1660: -- A validation or unexpected error has occurred
1661: ROLLBACK TO update_location_legal_adr;

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

1660: -- A validation or unexpected error has occurred
1661: ROLLBACK TO update_location_legal_adr;
1662: -- Reset IN OUT parameters.
1663: p_object_version_number := l_temp_ovn;
1664: hr_utility.set_location(' Leaving:'||l_proc, 90);
1665: RAISE;
1666: --
1667: --
1668: END update_location_legal_adr;

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

1692: l_temp_ovn number := p_object_version_number;
1693: --
1694: BEGIN
1695: --
1696: hr_utility.set_location('Entering:'|| l_proc, 10);
1697: --
1698: -- Issue a savepoint
1699: --
1700: savepoint disable_location_legal_adr;

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

1698: -- Issue a savepoint
1699: --
1700: savepoint disable_location_legal_adr;
1701: --
1702: hr_utility.set_location(l_proc, 20);
1703: --
1704: -- Process Logic
1705: --
1706: l_object_version_number := p_object_version_number;

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

1739: ,p_legal_address_flag => NULL
1740: );
1741:
1742: --
1743: hr_utility.set_location(l_proc, 60);
1744: --
1745: -- Bug fix 3205662.
1746: -- User hook call added.
1747: --

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

1776: -- never reached, so p_object_version_number is passed back unchanged.
1777: --
1778: p_object_version_number := l_object_version_number;
1779: --
1780: hr_utility.set_location(' Leaving:'||l_proc, 70);
1781: EXCEPTION
1782: --
1783: WHEN hr_api.validate_enabled THEN
1784: --

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

1791: -- (Any key or derived arguments must be set to null
1792: -- when validation only mode is being used.)
1793: -- Reset IN OUT parameters.
1794: p_object_version_number := l_temp_ovn;
1795: hr_utility.set_location(' Leaving:'||l_proc, 80);
1796: WHEN OTHERS THEN
1797: --
1798: -- A validation or unexpected error has occurred
1799: ROLLBACK TO disable_location_legal_adr;

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

1798: -- A validation or unexpected error has occurred
1799: ROLLBACK TO disable_location_legal_adr;
1800: -- Reset IN OUT parameters.
1801: p_object_version_number := l_temp_ovn;
1802: hr_utility.set_location(' Leaving:'||l_proc, 90);
1803: RAISE;
1804: --
1805: END disable_location_legal_adr;
1806: --

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

1822: l_temp_ovn number := p_object_version_number;
1823: --
1824: BEGIN
1825: --
1826: hr_utility.set_location('Entering:'|| l_proc, 10);
1827: --
1828: -- Issue a savepoint
1829: --
1830: savepoint enable_location_legal_adr;

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

1828: -- Issue a savepoint
1829: --
1830: savepoint enable_location_legal_adr;
1831: --
1832: hr_utility.set_location(l_proc, 20);
1833: --
1834: -- Process Logic
1835: --
1836: l_object_version_number := p_object_version_number;

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

1869: ,p_legal_address_flag => 'Y'
1870: );
1871:
1872: --
1873: hr_utility.set_location(l_proc, 60);
1874: --
1875: -- Bug fix 3205662.
1876: -- User hook call added.
1877: --

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

1905: -- never reached, so p_object_version_number is passed back unchanged.
1906: --
1907: p_object_version_number := l_object_version_number;
1908: --
1909: hr_utility.set_location(' Leaving:'||l_proc, 70);
1910: EXCEPTION
1911: --
1912: WHEN hr_api.validate_enabled THEN
1913: --

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

1920: -- (Any key or derived arguments must be set to null
1921: -- when validation only mode is being used.)
1922: -- Reset IN OUT parameters.
1923: p_object_version_number := l_temp_ovn;
1924: hr_utility.set_location(' Leaving:'||l_proc, 80);
1925: WHEN OTHERS THEN
1926: --
1927: -- A validation or unexpected error has occurred
1928: ROLLBACK TO enable_location_legal_adr;

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

1927: -- A validation or unexpected error has occurred
1928: ROLLBACK TO enable_location_legal_adr;
1929: -- Reset IN OUT parameters.
1930: p_object_version_number := l_temp_ovn;
1931: hr_utility.set_location(' Leaving:'||l_proc, 90);
1932: RAISE;
1933: --
1934: END enable_location_legal_adr;
1935: --