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

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

254: l_warning BOOLEAN;
255: --
256: BEGIN
257: --
258: hr_utility.set_location('Entering:'||l_proc,10);
259: --
260: -- Only process if contexts exist for the item
261: --
262: OPEN csr_template_item_contexts

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

270: RETURN;
271: END IF;
272: CLOSE csr_template_item_contexts;
273: --
274: hr_utility.set_location(l_proc,20);
275: --
276: -- Get the original item properties
277: --
278: OPEN csr_template_items

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

281: );
282: FETCH csr_template_items INTO l_template_item;
283: CLOSE csr_template_items;
284: --
285: hr_utility.set_location(l_proc,30);
286: --
287: -- For each item context
288: --
289: FOR l_template_item_context IN csr_template_item_contexts

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

291: ,p_template_item_id => p_template_item_id
292: )
293: LOOP
294: --
295: hr_utility.set_location(l_proc,40);
296: --
297: -- If context property equals previous item property then context property
298: -- becomes new item property.
299: --

Line 593: hr_utility.set_location('Leaving:'||l_proc,1000);

589: );
590: --
591: END LOOP;
592: --
593: hr_utility.set_location('Leaving:'||l_proc,1000);
594: --
595: END update_template_item_contexts;
596: --
597: -- ----------------------------------------------------------------------------

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

663: l_language_code fnd_languages.language_code%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Issue a savepoint
670: --
671: savepoint copy_template_item;

Line 704: hr_utility.set_location('Entering:'|| l_proc, 15);

700: end;
701: --
702: -- Validation in addition to Row Handlers
703: --
704: hr_utility.set_location('Entering:'|| l_proc, 15);
705:
706: OPEN cur_api_val;
707: FETCH cur_api_val INTO l_temp;
708: IF (cur_api_val%NOTFOUND AND

Line 723: hr_utility.set_location('Entering:'|| l_proc, 20);

719: --
720: -- Process Logic
721: --
722:
723: hr_utility.set_location('Entering:'|| l_proc, 20);
724:
725: OPEN cur_form_item;
726: FETCH cur_form_item INTO l_form_item_id;
727: CLOSE cur_form_item;

Line 729: hr_utility.set_location('Entering:'|| l_proc, 25);

725: OPEN cur_form_item;
726: FETCH cur_form_item INTO l_form_item_id;
727: CLOSE cur_form_item;
728:
729: hr_utility.set_location('Entering:'|| l_proc, 25);
730:
731: hr_tim_ins.ins( p_form_template_id => p_form_template_id
732: ,p_form_item_id => l_form_item_id
733: ,p_template_item_id => l_template_item_id_to

Line 736: hr_utility.set_location('Entering:'|| l_proc, 30);

732: ,p_form_item_id => l_form_item_id
733: ,p_template_item_id => l_template_item_id_to
734: ,p_object_version_number => l_object_version_number);
735:
736: hr_utility.set_location('Entering:'|| l_proc, 30);
737:
738: hr_item_properties_bsi.copy_item_property(
739: p_effective_date => TRUNC(p_effective_date)
740: ,p_language_code => l_language_code

Line 747: hr_utility.set_location('Entering:'|| l_proc, 35);

743: ,p_item_property_id => l_item_property_id
744: ,p_object_version_number => l_object_version_number);
745: --,p_override_value_warning => l_override_value_warning);
746:
747: hr_utility.set_location('Entering:'|| l_proc, 35);
748:
749: FOR cur_rec in cur_tab_page LOOP
750:
751: hr_template_item_tab_pages_api.create_template_item_tab_page(

Line 759: hr_utility.set_location('Entering:'|| l_proc, 40);

755: ,p_template_item_tab_page_id => l_template_item_tab_page_id
756: ,p_object_version_number => l_ovn_item);
757: END LOOP;
758:
759: hr_utility.set_location('Entering:'|| l_proc, 40);
760:
761: FOR cur_rec in cur_item_context LOOP
762: hr_template_item_contexts_api.copy_template_item_context(
763: p_effective_date => TRUNC(p_effective_date)

Line 773: hr_utility.set_location('Entering:'|| l_proc, 45);

769: ,p_item_context_id => l_item_context_id
770: ,p_concatenated_segments => l_concatenated_segments);
771: END LOOP;
772:
773: hr_utility.set_location('Entering:'|| l_proc, 45);
774:
775: --
776: -- Call After Process User Hook
777: --

Line 797: hr_utility.set_location('Entering:'|| l_proc, 50);

793: end;
794: --
795: -- When in validation only mode raise the Validate_Enabled exception
796: --
797: hr_utility.set_location('Entering:'|| l_proc, 50);
798:
799: if p_validate then
800: raise hr_api.validate_enabled;
801: end if;

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

804: --
805: p_template_item_id_to := l_template_item_id_to;
806: p_object_version_number := l_object_version_number;
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 70);
809: exception
810: when hr_api.validate_enabled then
811: --
812: -- As the Validate_Enabled exception has been raised

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

819: -- when validation only mode is being used.)
820: --
821: p_template_item_id_to := null;
822: p_object_version_number := null;
823: hr_utility.set_location(' Leaving:'||l_proc, 80);
824: when others then
825: --
826: -- A validation or unexpected error has occured
827: --

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

828: p_template_item_id_to := null;
829: p_object_version_number := null;
830:
831: rollback to copy_template_item;
832: hr_utility.set_location(' Leaving:'||l_proc, 90);
833: raise;
834: end copy_template_item;
835: --
836: -- ----------------------------------------------------------------------------

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

949: l_ovn_tab number;
950: l_language_code fnd_languages.language_code%TYPE;
951:
952: begin
953: hr_utility.set_location('Entering:'|| l_proc, 10);
954: --
955: -- Issue a savepoint
956: --
957: savepoint create_template_item;

Line 1061: hr_utility.set_location('Entering:'|| l_proc, 15);

1057: --
1058: -- Validation in addition to Row Handlers
1059: --
1060:
1061: hr_utility.set_location('Entering:'|| l_proc, 15);
1062:
1063: OPEN cur_override;
1064: FETCH cur_override INTO l_required_override,l_visible_override;
1065: CLOSE cur_override;

Line 1067: hr_utility.set_location('Entering:'|| l_proc, 20);

1063: OPEN cur_override;
1064: FETCH cur_override INTO l_required_override,l_visible_override;
1065: CLOSE cur_override;
1066:
1067: hr_utility.set_location('Entering:'|| l_proc, 20);
1068:
1069: IF ( p_required <> hr_api.g_number ) AND
1070: ( l_required_override is not null AND p_required is not null ) THEN
1071: l_override_value_warning := TRUE;

Line 1074: hr_utility.set_location('Entering:'|| l_proc, 25);

1070: ( l_required_override is not null AND p_required is not null ) THEN
1071: l_override_value_warning := TRUE;
1072: END IF;
1073:
1074: hr_utility.set_location('Entering:'|| l_proc, 25);
1075:
1076: IF ( p_visible <> hr_api.g_number ) AND
1077: ( l_visible_override is not null AND p_visible is not null ) THEN
1078: l_override_value_warning := TRUE;

Line 1081: hr_utility.set_location('Entering:'|| l_proc, 30);

1077: ( l_visible_override is not null AND p_visible is not null ) THEN
1078: l_override_value_warning := TRUE;
1079: END IF;
1080:
1081: hr_utility.set_location('Entering:'|| l_proc, 30);
1082:
1083: OPEN cur_api_val;
1084: FETCH cur_api_val INTO l_temp;
1085: IF (cur_api_val%NOTFOUND AND

Line 1096: hr_utility.set_location('Entering:'|| l_proc, 35);

1092: fnd_message.raise_error;
1093: END IF;
1094: CLOSE cur_api_val;
1095:
1096: hr_utility.set_location('Entering:'|| l_proc, 35);
1097:
1098: --
1099: --
1100: -- Process Logic

Line 1107: hr_utility.set_location('Entering:'|| l_proc, 40);

1103: ,p_form_item_id => p_form_item_id
1104: ,p_template_item_id => l_template_item_id
1105: ,p_object_version_number => l_object_version_number);
1106:
1107: hr_utility.set_location('Entering:'|| l_proc, 40);
1108:
1109: hr_item_properties_bsi.copy_item_property(
1110: p_effective_date => TRUNC(p_effective_date)
1111: ,p_language_code => l_language_code

Line 1188: hr_utility.set_location('Entering:'|| l_proc, 45);

1184: ,p_item_property_id => l_item_property_id
1185: ,p_object_version_number => l_object_version_number);
1186: --,p_override_value_warning => l_override_value_warning);
1187:
1188: hr_utility.set_location('Entering:'|| l_proc, 45);
1189:
1190: IF p_template_tab_page_id is not null THEN
1191: hr_template_item_tab_pages_api.create_template_item_tab_page(
1192: p_effective_date => TRUNC(p_effective_date)

Line 1199: hr_utility.set_location('Entering:'|| l_proc, 50);

1195: ,p_template_item_tab_page_id => l_template_item_tab_page_id
1196: ,p_object_version_number => l_ovn_tab);
1197: END IF;
1198:
1199: hr_utility.set_location('Entering:'|| l_proc, 50);
1200:
1201: --
1202: -- Call After Process User Hook
1203: --

Line 1294: hr_utility.set_location('Entering:'|| l_proc, 55);

1290: end;
1291: --
1292: -- When in validation only mode raise the Validate_Enabled exception
1293: --
1294: hr_utility.set_location('Entering:'|| l_proc, 55);
1295:
1296: if p_validate then
1297: raise hr_api.validate_enabled;
1298: end if;

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

1302: p_template_item_id := l_template_item_id;
1303: p_object_version_number := l_object_version_number;
1304: p_override_value_warning := l_override_value_warning;
1305: --
1306: hr_utility.set_location(' Leaving:'||l_proc, 70);
1307: exception
1308: when hr_api.validate_enabled then
1309: --
1310: -- As the Validate_Enabled exception has been raised

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

1318: --
1319: p_template_item_id := null;
1320: p_override_value_warning := FALSE;
1321: p_object_version_number := null;
1322: hr_utility.set_location(' Leaving:'||l_proc, 80);
1323: when others then
1324: --
1325: -- A validation or unexpected error has occured
1326: --

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

1328: p_override_value_warning := null;
1329: p_object_version_number := null;
1330:
1331: rollback to create_template_item;
1332: hr_utility.set_location(' Leaving:'||l_proc, 90);
1333: raise;
1334: end create_template_item;
1335: --
1336: -- ----------------------------------------------------------------------------

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

1385: ---- Fix For Bug 6631115 Ends ---------
1386:
1387: l_proc varchar2(72) := g_package||'delete_template_item';
1388: begin
1389: hr_utility.set_location('Entering:'|| l_proc, 10);
1390: --
1391: -- Issue a savepoint
1392: --
1393: savepoint delete_template_item;

Line 1414: hr_utility.set_location('Entering:'|| l_proc, 15);

1410: end;
1411: --
1412: -- Validation in addition to Row Handlers
1413: --
1414: hr_utility.set_location('Entering:'|| l_proc, 15);
1415:
1416: OPEN cur_api_val;
1417: FETCH cur_api_val INTO l_temp;
1418: IF (cur_api_val%NOTFOUND AND

Line 1432: hr_utility.set_location('Entering:'|| l_proc, 15);

1428: --
1429: --
1430: -- Process Logic
1431: --
1432: hr_utility.set_location('Entering:'|| l_proc, 15);
1433:
1434: IF p_delete_children_flag = 'Y' THEN
1435: FOR cur_rec IN cur_item_context LOOP
1436: hr_template_item_contexts_api.delete_template_item_context(

Line 1443: hr_utility.set_location('Entering:'|| l_proc, 30);

1439: --,p_delete_children_flag => p_delete_children_flag);
1440: END LOOP;
1441: END IF;
1442:
1443: hr_utility.set_location('Entering:'|| l_proc, 30);
1444:
1445: FOR cur_rec IN cur_tab_page LOOP
1446: hr_template_item_tab_pages_api.delete_template_item_tab_page(
1447: p_template_item_tab_page_id => cur_rec.template_item_tab_page_id

Line 1451: hr_utility.set_location('Entering:'|| l_proc, 35);

1447: p_template_item_tab_page_id => cur_rec.template_item_tab_page_id
1448: ,p_object_version_number => cur_rec.object_version_number);
1449: END LOOP;
1450:
1451: hr_utility.set_location('Entering:'|| l_proc, 35);
1452:
1453: hr_item_properties_bsi.delete_item_property
1454: (p_template_item_id => p_template_item_id
1455: ,p_object_version_number => p_object_version_number);

Line 1457: hr_utility.set_location('Entering:'|| l_proc, 40);

1453: hr_item_properties_bsi.delete_item_property
1454: (p_template_item_id => p_template_item_id
1455: ,p_object_version_number => p_object_version_number);
1456:
1457: hr_utility.set_location('Entering:'|| l_proc, 40);
1458:
1459: ---- Fix For Bug 6631115 Starts -----
1460:
1461: open cur_template_item;

Line 1471: hr_utility.set_location('Entering:'|| l_proc, 45);

1467: close cur_template_item;
1468:
1469: ---- Fix For Bug 6631115 Ends -------
1470:
1471: hr_utility.set_location('Entering:'|| l_proc, 45);
1472:
1473: --
1474: -- Call After Process User Hook
1475: --

Line 1492: hr_utility.set_location('Entering:'|| l_proc, 50);

1488: end;
1489: --
1490: -- When in validation only mode raise the Validate_Enabled exception
1491: --
1492: hr_utility.set_location('Entering:'|| l_proc, 50);
1493:
1494: if p_validate then
1495: raise hr_api.validate_enabled;
1496: end if;

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

1494: if p_validate then
1495: raise hr_api.validate_enabled;
1496: end if;
1497: --
1498: hr_utility.set_location(' Leaving:'||l_proc, 70);
1499: exception
1500: when hr_api.validate_enabled then
1501: --
1502: -- As the Validate_Enabled exception has been raised

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

1507: -- Only set output warning arguments
1508: -- (Any key or derived arguments must be set to null
1509: -- when validation only mode is being used.)
1510: --
1511: hr_utility.set_location(' Leaving:'||l_proc, 80);
1512: when others then
1513: --
1514: -- A validation or unexpected error has occured
1515: --

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

1513: --
1514: -- A validation or unexpected error has occured
1515: --
1516: rollback to delete_template_item;
1517: hr_utility.set_location(' Leaving:'||l_proc, 90);
1518: raise;
1519: end delete_template_item;
1520: --
1521: -- ----------------------------------------------------------------------------

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

1633: l_override_value_warning boolean := FALSE;
1634: l_language_code fnd_languages.language_code%TYPE;
1635:
1636: begin
1637: hr_utility.set_location('Entering:'|| l_proc, 10);
1638: --
1639: -- Issue a savepoint
1640: --
1641: savepoint update_template_item;

Line 1746: hr_utility.set_location('Entering:'|| l_proc, 15);

1742: end;
1743: --
1744: -- Validation in addition to Row Handlers
1745: --
1746: hr_utility.set_location('Entering:'|| l_proc, 15);
1747:
1748: OPEN cur_override;
1749: FETCH cur_override INTO l_required_override,l_visible_override;
1750: CLOSE cur_override;

Line 1752: hr_utility.set_location('Entering:'|| l_proc, 20);

1748: OPEN cur_override;
1749: FETCH cur_override INTO l_required_override,l_visible_override;
1750: CLOSE cur_override;
1751:
1752: hr_utility.set_location('Entering:'|| l_proc, 20);
1753:
1754: IF ( p_required <> hr_api.g_number ) AND
1755: ( l_required_override is not null AND p_required is not null ) THEN
1756: l_override_value_warning := TRUE;

Line 1759: hr_utility.set_location('Entering:'|| l_proc, 25);

1755: ( l_required_override is not null AND p_required is not null ) THEN
1756: l_override_value_warning := TRUE;
1757: END IF;
1758:
1759: hr_utility.set_location('Entering:'|| l_proc, 25);
1760:
1761: IF ( p_visible <> hr_api.g_number ) AND
1762: ( l_visible_override is not null AND p_visible is not null ) THEN
1763: l_override_value_warning := TRUE;

Line 1766: hr_utility.set_location('Entering:'|| l_proc, 30);

1762: ( l_visible_override is not null AND p_visible is not null ) THEN
1763: l_override_value_warning := TRUE;
1764: END IF;
1765:
1766: hr_utility.set_location('Entering:'|| l_proc, 30);
1767:
1768: OPEN cur_api_val;
1769: FETCH cur_api_val INTO l_temp;
1770: IF (cur_api_val%NOTFOUND AND

Line 1781: hr_utility.set_location('Entering:'|| l_proc, 35);

1777: fnd_message.raise_error;
1778: END IF;
1779: CLOSE cur_api_val;
1780:
1781: hr_utility.set_location('Entering:'|| l_proc, 35);
1782:
1783: --
1784: --
1785: -- Process Logic

Line 1787: hr_utility.set_location('Entering:'|| l_proc, 40);

1783: --
1784: --
1785: -- Process Logic
1786: --
1787: hr_utility.set_location('Entering:'|| l_proc, 40);
1788: --
1789: if (p_upd_template_item_contexts) then
1790: update_template_item_contexts
1791: (p_effective_date => p_effective_date

Line 1867: hr_utility.set_location('Entering:'|| l_proc, 42);

1863: ,p_information30 => p_information30
1864: );
1865: end if;
1866: --
1867: hr_utility.set_location('Entering:'|| l_proc, 42);
1868: --
1869: hr_item_properties_bsi.update_item_property(
1870: p_effective_date => TRUNC(p_effective_date)
1871: ,p_language_code => l_language_code

Line 1946: hr_utility.set_location('Entering:'|| l_proc, 45);

1942: ,p_next_navigation_item_id => p_next_navigation_item_id
1943: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1944: --,p_override_value_warning => l_override_value_warning);
1945:
1946: hr_utility.set_location('Entering:'|| l_proc, 45);
1947:
1948: --
1949: -- Call After Process User Hook
1950: --

Line 2039: hr_utility.set_location('Entering:'|| l_proc, 50);

2035: end;
2036: --
2037: -- When in validation only mode raise the Validate_Enabled exception
2038: --
2039: hr_utility.set_location('Entering:'|| l_proc, 50);
2040:
2041: if p_validate then
2042: raise hr_api.validate_enabled;
2043: end if;

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

2046: --
2047: p_object_version_number := l_object_version_number;
2048: p_override_value_warning := l_override_value_warning;
2049: --
2050: hr_utility.set_location(' Leaving:'||l_proc, 70);
2051: exception
2052: when hr_api.validate_enabled then
2053: --
2054: -- As the Validate_Enabled exception has been raised

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

2060: -- (Any key or derived arguments must be set to null
2061: -- when validation only mode is being used.)
2062: --
2063: p_override_value_warning := l_override_value_warning;
2064: hr_utility.set_location(' Leaving:'||l_proc, 80);
2065: when others then
2066: --
2067: -- A validation or unexpected error has occured
2068: --

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

2066: --
2067: -- A validation or unexpected error has occured
2068: --
2069: rollback to update_template_item;
2070: hr_utility.set_location(' Leaving:'||l_proc, 90);
2071: raise;
2072: end update_template_item;
2073: --
2074: end hr_template_items_api;