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

Line 107: hr_utility.set_location('Entering:'|| l_proc, 5);

103: l_proc varchar2(72) := g_package||'create_competence_elements';
104: l_competence_element_id per_competence_elements.competence_id%TYPE;
105: l_object_version_number per_competence_elements.object_version_number%TYPE;
106: begin
107: hr_utility.set_location('Entering:'|| l_proc, 5);
108: --
109: -- Issue a savepoint.
110: --
111: savepoint create_competence_element;

Line 112: hr_utility.set_location(l_proc, 6);

108: --
109: -- Issue a savepoint.
110: --
111: savepoint create_competence_element;
112: hr_utility.set_location(l_proc, 6);
113: --
114: -- Call Before Process User Hook
115: --
116: begin

Line 213: hr_utility.set_location(l_proc, 7);

209: -- End of Before Process User Hook call
210: --
211: -- Validation in addition to Table Handlers
212: --
213: hr_utility.set_location(l_proc, 7);
214: --
215: -- Process Logic
216: --
217: per_cel_ins.ins (

Line 305: hr_utility.set_location(l_proc, 8);

301: ,p_achieved_date => p_achieved_date
302: ,p_appr_line_score => p_appr_line_score
303: );
304: --
305: hr_utility.set_location(l_proc, 8);
306: --
307: --
308: -- Call After Process User Hook
309: --

Line 418: hr_utility.set_location(' Leaving:'||l_proc, 11);

414: --
415: p_competence_element_id := l_competence_element_id;
416: p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 11);
419: exception
420: when hr_api.validate_enabled then
421: --
422: -- As the Validate_Enabled exception has been raised

Line 445: hr_utility.set_location(' Leaving:'||l_proc, 12);

441: raise;
442: --
443: -- End of fix.
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 12);
446: end create_competence_element;
447: --
448: --
449: -- ---------------------------------------------------------------------------

Line 536: hr_utility.set_location('Entering:'|| l_proc, 5);

532: --
533: lv_object_version_number per_competence_elements.object_version_number%TYPE := p_object_version_number ;
534: --
535: begin
536: hr_utility.set_location('Entering:'|| l_proc, 5);
537: --
538: -- Issue a savepoint.
539: --
540: savepoint update_competence_element;

Line 541: hr_utility.set_location(l_proc, 6);

537: --
538: -- Issue a savepoint.
539: --
540: savepoint update_competence_element;
541: hr_utility.set_location(l_proc, 6);
542: --
543: -- Call Before Process User Hook
544: --
545: begin

Line 628: hr_utility.set_location(l_proc, 7);

624: -- End of Before Process User Hook call
625: --
626: -- Validation in addition to Table Handlers
627: --
628: hr_utility.set_location(l_proc, 7);
629: --
630: -- Process Logic
631: --
632: l_object_version_number := p_object_version_number;

Line 709: hr_utility.set_location(l_proc, 8);

705: );
706: --
707: --
708: --
709: hr_utility.set_location(l_proc, 8);
710: --
711: -- Call After Process User Hook
712: --
713: begin

Line 801: hr_utility.set_location(' Leaving:'||l_proc, 11);

797: raise hr_api.validate_enabled;
798: end if;
799: --
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 11);
802: exception
803: when hr_api.validate_enabled then
804: --
805: -- As the Validate_Enabled exception has been raised

Line 829: hr_utility.set_location(' Leaving:'||l_proc, 12);

825: raise;
826: --
827: -- End of fix.
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 12);
830: --
831: end update_competence_element;
832: --
833: --

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

896: where competence_element_id = p_competence_element_id;
897: --
898:
899: begin
900: hr_utility.set_location('Entering:'|| l_proc, 10);
901: --
902: -- get party_id from per_competence_elements using competence_element_id
903: --
904: open csr_get_party_id;

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

903: --
904: open csr_get_party_id;
905: fetch csr_get_party_id into l_party_id;
906: close csr_get_party_id;
907: hr_utility.set_location(l_proc, 20);
908: --
909: --
910: --
911: update_competence_element

Line 960: hr_utility.set_location(' Leaving:'||l_proc, 100);

956: );
957: --
958: --
959: --
960: hr_utility.set_location(' Leaving:'||l_proc, 100);
961: --
962: end update_competence_element;
963:
964: -- ---------------------------------------------------------------------------

Line 1097: hr_utility.set_location('Entering:'|| l_proc, 5);

1093: where competence_element_id = p_competence_element_id
1094: and object_version_number = p_object_version_number;
1095: --
1096: begin
1097: hr_utility.set_location('Entering:'|| l_proc, 5);
1098: --
1099: -- Issue a savepoint.
1100: --
1101: savepoint update_competence_element;

Line 1102: hr_utility.set_location(l_proc, 6);

1098: --
1099: -- Issue a savepoint.
1100: --
1101: savepoint update_competence_element;
1102: hr_utility.set_location(l_proc, 6);
1103: --
1104: -- Call Before Process User Hook
1105: --
1106: begin

Line 1154: hr_utility.set_location(l_proc, 7);

1150: -- End of Before Process User hook
1151: --
1152: -- Validation in addition to Table Handlers
1153: --
1154: hr_utility.set_location(l_proc, 7);
1155: --
1156: -- only do the following logic if the effective_date_from is entered.
1157: --
1158: if (p_effective_date_from is not null) then

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

1197: l_attribute18,
1198: l_attribute19,
1199: l_attribute20;
1200: if csr_comp_element%notfound then
1201: hr_utility.set_location(l_proc, 8);
1202: close csr_comp_element;
1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then

Line 1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1199: l_attribute20;
1200: if csr_comp_element%notfound then
1201: hr_utility.set_location(l_proc, 8);
1202: close csr_comp_element;
1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then
1206: hr_utility.set_location(l_proc, 9);
1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');

Line 1204: hr_utility.raise_error;

1200: if csr_comp_element%notfound then
1201: hr_utility.set_location(l_proc, 8);
1202: close csr_comp_element;
1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then
1206: hr_utility.set_location(l_proc, 9);
1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');
1208: hr_utility.raise_error;

Line 1206: hr_utility.set_location(l_proc, 9);

1202: close csr_comp_element;
1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then
1206: hr_utility.set_location(l_proc, 9);
1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');
1208: hr_utility.raise_error;
1209: elsif (
1210: l_effective_date_from <> p_effective_date_from and

Line 1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');

1203: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then
1206: hr_utility.set_location(l_proc, 9);
1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');
1208: hr_utility.raise_error;
1209: elsif (
1210: l_effective_date_from <> p_effective_date_from and
1211: ((l_proficiency_level_id is not null

Line 1208: hr_utility.raise_error;

1204: hr_utility.raise_error;
1205: elsif (l_type <> 'PERSONAL') then
1206: hr_utility.set_location(l_proc, 9);
1207: hr_utility.set_message(801, 'HR_51866_CEL_INV_COMP_TYPE');
1208: hr_utility.raise_error;
1209: elsif (
1210: l_effective_date_from <> p_effective_date_from and
1211: ((l_proficiency_level_id is not null
1212: and p_proficiency_level_id is null) OR (l_proficiency_level_id is null and

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

1227: if (p_effective_date_to is not null ) then
1228: --
1229: -- the effective_date_to is also changed.
1230: --
1231: hr_utility.set_location(l_proc, 15);
1232: l_upd_date_to := p_effective_date_to;
1233: --
1234: end if;
1235: --

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

1237: --
1238: if (p_effective_date_to is not null and
1239: p_effective_date_to > l_effective_date_from) then
1240: --
1241: hr_utility.set_location(l_proc, 20);
1242: hr_utility.set_message(801, 'HR_51867_CEL_DATE_OVERLAP');
1243: hr_utility.raise_error;
1244: elsif(p_effective_date_to is null) then
1245: --

Line 1242: hr_utility.set_message(801, 'HR_51867_CEL_DATE_OVERLAP');

1238: if (p_effective_date_to is not null and
1239: p_effective_date_to > l_effective_date_from) then
1240: --
1241: hr_utility.set_location(l_proc, 20);
1242: hr_utility.set_message(801, 'HR_51867_CEL_DATE_OVERLAP');
1243: hr_utility.raise_error;
1244: elsif(p_effective_date_to is null) then
1245: --
1246: hr_utility.set_location(l_proc, 25);

Line 1243: hr_utility.raise_error;

1239: p_effective_date_to > l_effective_date_from) then
1240: --
1241: hr_utility.set_location(l_proc, 20);
1242: hr_utility.set_message(801, 'HR_51867_CEL_DATE_OVERLAP');
1243: hr_utility.raise_error;
1244: elsif(p_effective_date_to is null) then
1245: --
1246: hr_utility.set_location(l_proc, 25);
1247: l_upd_date_to := l_effective_date_from -1;

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

1242: hr_utility.set_message(801, 'HR_51867_CEL_DATE_OVERLAP');
1243: hr_utility.raise_error;
1244: elsif(p_effective_date_to is null) then
1245: --
1246: hr_utility.set_location(l_proc, 25);
1247: l_upd_date_to := l_effective_date_from -1;
1248: --
1249: end if;
1250: --

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

1295: );
1296: --
1297: --
1298: --
1299: hr_utility.set_location(l_proc, 30);
1300: --
1301: -- Now, insert a row if necessary.
1302: --
1303: if (l_insert) then

Line 1304: hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);

1300: --
1301: -- Now, insert a row if necessary.
1302: --
1303: if (l_insert) then
1304: hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);
1305: hr_utility.set_location ('type ***' || l_type, 32);
1306: hr_utility.set_location ('person **' || to_char(l_person_id),33);
1307: hr_utility.set_location ('date_from**' || to_char(l_effective_date_from),34);
1308: per_cel_ins.ins (

Line 1305: hr_utility.set_location ('type ***' || l_type, 32);

1301: -- Now, insert a row if necessary.
1302: --
1303: if (l_insert) then
1304: hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);
1305: hr_utility.set_location ('type ***' || l_type, 32);
1306: hr_utility.set_location ('person **' || to_char(l_person_id),33);
1307: hr_utility.set_location ('date_from**' || to_char(l_effective_date_from),34);
1308: per_cel_ins.ins (
1309: p_competence_element_id => l_ins_comp_id

Line 1306: hr_utility.set_location ('person **' || to_char(l_person_id),33);

1302: --
1303: if (l_insert) then
1304: hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);
1305: hr_utility.set_location ('type ***' || l_type, 32);
1306: hr_utility.set_location ('person **' || to_char(l_person_id),33);
1307: hr_utility.set_location ('date_from**' || to_char(l_effective_date_from),34);
1308: per_cel_ins.ins (
1309: p_competence_element_id => l_ins_comp_id
1310: ,p_object_version_number => l_ins_ovn

Line 1307: hr_utility.set_location ('date_from**' || to_char(l_effective_date_from),34);

1303: if (l_insert) then
1304: hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);
1305: hr_utility.set_location ('type ***' || l_type, 32);
1306: hr_utility.set_location ('person **' || to_char(l_person_id),33);
1307: hr_utility.set_location ('date_from**' || to_char(l_effective_date_from),34);
1308: per_cel_ins.ins (
1309: p_competence_element_id => l_ins_comp_id
1310: ,p_object_version_number => l_ins_ovn
1311: ,p_business_group_id => l_business_group_id

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

1345: ,p_validate => p_validate
1346: ,p_party_id => l_party_id -- HR/TCA merge
1347: );
1348: --
1349: hr_utility.set_location(l_proc, 35);
1350: --
1351: end if;
1352: --
1353: -- Call After Process User Hook

Line 1410: hr_utility.set_location(' Leaving:'||l_proc, 40);

1406: raise hr_api.validate_enabled;
1407: end if;
1408: --
1409: --
1410: hr_utility.set_location(' Leaving:'||l_proc, 40);
1411: exception
1412: when hr_api.validate_enabled then
1413: --
1414: -- As the Validate_Enabled exception has been raised

Line 1443: hr_utility.set_location(' Leaving:'||l_proc, 45);

1439: raise;
1440: --
1441: -- End of fix.
1442: --
1443: hr_utility.set_location(' Leaving:'||l_proc, 45);
1444: --
1445: end update_personal_comp_element;
1446: --
1447: --

Line 1463: hr_utility.set_location('Entering:'|| l_proc, 5);

1459: --
1460: --
1461: l_proc varchar2(72) := g_package||'delete_competence_element';
1462: begin
1463: hr_utility.set_location('Entering:'|| l_proc, 5);
1464: --
1465: -- Issue a savepoint.
1466: --
1467: savepoint delete_competence_element;

Line 1468: hr_utility.set_location(l_proc, 6);

1464: --
1465: -- Issue a savepoint.
1466: --
1467: savepoint delete_competence_element;
1468: hr_utility.set_location(l_proc, 6);
1469: --
1470: -- Call Before Process User Hook
1471: --
1472: begin

Line 1490: hr_utility.set_location(l_proc, 7);

1486: -- End of Before Process User hook
1487: --
1488: -- Validation in addition to Table Handlers
1489: --
1490: hr_utility.set_location(l_proc, 7);
1491: --
1492: -- Process Logic
1493: --
1494: --

Line 1503: hr_utility.set_location(l_proc, 8);

1499: ,p_competence_element_id => p_competence_element_id
1500: ,p_object_version_number => p_object_version_number
1501: );
1502: --
1503: hr_utility.set_location(l_proc, 8);
1504: --
1505: -- Call After Process User Hook
1506: --
1507: begin

Line 1528: hr_utility.set_location(' Leaving:'||l_proc, 11);

1524: if p_validate then
1525: raise hr_api.validate_enabled;
1526: end if;
1527: --
1528: hr_utility.set_location(' Leaving:'||l_proc, 11);
1529: exception
1530: when hr_api.validate_enabled then
1531: --
1532: -- As the Validate_Enabled exception has been raised

Line 1549: hr_utility.set_location(' Leaving:'||l_proc, 12);

1545: raise;
1546: --
1547: -- End of fix.
1548: --
1549: hr_utility.set_location(' Leaving:'||l_proc, 12);
1550: end delete_competence_element;
1551: --
1552: -- ---------------------------------------------------------------------------
1553: -- |--------------------< >------------------|

Line 2644: hr_utility.set_location ('Entering:' || v_proc, 5);

2640: = nvl(p_old_start_date,hr_api.g_sot))));
2641:
2642: Begin
2643: --
2644: hr_utility.set_location ('Entering:' || v_proc, 5);
2645: --
2646: -- Issue a savepoint.
2647: --
2648: savepoint update_delivered_dates;

Line 2820: hr_utility.set_location (' Leaving:' || v_proc, 5);

2816: --
2817: -- End of fix.
2818: --
2819: --
2820: hr_utility.set_location (' Leaving:' || v_proc, 5);
2821: --
2822: End update_delivered_dates;
2823: --
2824: end hr_competence_element_api;