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

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

218: where competence_definition_id = l_competence_definition_id;
219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'|| l_proc, 5);
223: hr_utility.set_location(l_competence_definition_id,67);
224: --
225: -- Issue a savepoint.
226: --

Line 223: hr_utility.set_location(l_competence_definition_id,67);

219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'|| l_proc, 5);
223: hr_utility.set_location(l_competence_definition_id,67);
224: --
225: -- Issue a savepoint.
226: --
227: if p_business_group_id is not null then

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

236: --
237: l_language_code := p_language_code;
238: hr_api.validate_language_code(p_language_code => l_language_code);
239:
240: hr_utility.set_location(l_proc, 6);
241: -- ngundura global competence allowed only if cross business group
242: -- profile is set
243: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') <> 'Y'
244: and p_business_group_id is null

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

251: then
252: open csr_comp_struct;
253: fetch csr_comp_struct into l_flex_num;
254: close csr_comp_struct;
255: hr_utility.set_location(l_proc, 7);
256: else
257: l_flex_num := fnd_profile.value('HR_GLOBAL_COMPETENCE');
258: end if;
259: --

Line 262: hr_utility.set_message(801,'HR_6035_ALL_INVALID_KEYFLEX');

258: end if;
259: --
260: if nvl(l_flex_num,hr_api.g_number) = hr_api.g_number
261: then
262: hr_utility.set_message(801,'HR_6035_ALL_INVALID_KEYFLEX');
263: hr_utility.raise_error;
264: end if;
265: --
266: if l_name is null and l_competence_definition_id is not null

Line 263: hr_utility.raise_error;

259: --
260: if nvl(l_flex_num,hr_api.g_number) = hr_api.g_number
261: then
262: hr_utility.set_message(801,'HR_6035_ALL_INVALID_KEYFLEX');
263: hr_utility.raise_error;
264: end if;
265: --
266: if l_name is null and l_competence_definition_id is not null
267: then

Line 268: hr_utility.set_location(l_proc, 13);

264: end if;
265: --
266: if l_name is null and l_competence_definition_id is not null
267: then
268: hr_utility.set_location(l_proc, 13);
269: open c_name;
270: fetch c_name into
271: l_name;
272: if c_name%NOTFOUND OR c_name%NOTFOUND IS NULL

Line 275: hr_utility.set_location(l_proc, 14);

271: l_name;
272: if c_name%NOTFOUND OR c_name%NOTFOUND IS NULL
273: then
274: l_name := NULL;
275: hr_utility.set_location(l_proc, 14);
276: end if;
277: close c_name;
278: end if;
279: --

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

281: and l_name is not null
282: --
283: then
284: --
285: hr_utility.set_location(l_proc, 15);
286: --
287: -- set indicator to show p_competence_definition_id did not enter pgm null
288: --
289: l_null_ind := 1;

Line 327: hr_utility.set_location(l_proc, 17);

323: if c_segments%NOTFOUND OR c_segments%NOTFOUND IS NULL
324: then
325: l_competence_definition_id := NULL;
326: l_null_ind := 0;
327: hr_utility.set_location(l_proc, 17);
328: end if;
329: close c_segments;
330: end if;
331: --

Line 433: hr_utility.set_location('hr_competences_bk1.create_competence_b',999);

429: p_information18 => p_information18,
430: p_information19 => p_information19,
431: p_information20 => p_information20
432: );
433: hr_utility.set_location('hr_competences_bk1.create_competence_b',999);
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'create_competence',

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

447: or l_name is null
448: then
449: l_null_ind := 0;
450: --
451: hr_utility.set_location(l_proc, 7);
452: --
453: -- Determine the competence defintion by calling ins_or_sel
454: --
455: hr_kflex_utility.ins_or_sel_keyflex_comb

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

566: p_information19 => p_information19,
567: p_information20 => p_information20
568: );
569: --
570: hr_utility.set_location(l_proc, 8);
571:
572: --
573: -- MLS Processing
574: --

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

709: p_object_version_number := l_object_version_number;
710: p_competence_definition_id := l_competence_definition_id;
711: p_name := l_name;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 11);
714: exception
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised

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

749: raise;
750: --
751: -- End of fix.
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 12);
754: end create_competence;
755: --
756: --
757: -- ---------------------------------------------------------------------------

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

967: where competence_definition_id = l_competence_definition_id;
968: --
969: begin
970: --
971: hr_utility.set_location('Entering:'|| l_proc, 5);
972: --
973: -- Issue a savepoint.
974: --
975: savepoint update_competence;

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

972: --
973: -- Issue a savepoint.
974: --
975: savepoint update_competence;
976: hr_utility.set_location(l_proc, 6);
977: hr_utility.set_location(l_competence_definition_id,69);
978: hr_utility.set_location(substr(l_name,1,128),691); --bug#2925181
979: --
980: if l_name is null and l_competence_definition_id is not null

Line 977: hr_utility.set_location(l_competence_definition_id,69);

973: -- Issue a savepoint.
974: --
975: savepoint update_competence;
976: hr_utility.set_location(l_proc, 6);
977: hr_utility.set_location(l_competence_definition_id,69);
978: hr_utility.set_location(substr(l_name,1,128),691); --bug#2925181
979: --
980: if l_name is null and l_competence_definition_id is not null
981: then

Line 978: hr_utility.set_location(substr(l_name,1,128),691); --bug#2925181

974: --
975: savepoint update_competence;
976: hr_utility.set_location(l_proc, 6);
977: hr_utility.set_location(l_competence_definition_id,69);
978: hr_utility.set_location(substr(l_name,1,128),691); --bug#2925181
979: --
980: if l_name is null and l_competence_definition_id is not null
981: then
982: hr_utility.set_location(l_proc, 13);

Line 982: hr_utility.set_location(l_proc, 13);

978: hr_utility.set_location(substr(l_name,1,128),691); --bug#2925181
979: --
980: if l_name is null and l_competence_definition_id is not null
981: then
982: hr_utility.set_location(l_proc, 13);
983: open c_name;
984: fetch c_name into
985: l_name;
986: if c_name%NOTFOUND OR c_name%NOTFOUND IS NULL

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

985: l_name;
986: if c_name%NOTFOUND OR c_name%NOTFOUND IS NULL
987: then
988: l_name := NULL;
989: hr_utility.set_location(l_proc, 14);
990: end if;
991: close c_name;
992: end if;
993: --

Line 1039: hr_utility.set_location(l_proc, 24);

1035: if c_segments%NOTFOUND OR c_segments%NOTFOUND IS NULL
1036: then
1037: l_competence_definition_id := NULL;
1038: l_null_ind := 0;
1039: hr_utility.set_location(l_proc, 24);
1040: end if;
1041: close c_segments;
1042: hr_utility.set_location(l_proc, 27);
1043: --

Line 1042: hr_utility.set_location(l_proc, 27);

1038: l_null_ind := 0;
1039: hr_utility.set_location(l_proc, 24);
1040: end if;
1041: close c_segments;
1042: hr_utility.set_location(l_proc, 27);
1043: --
1044: end if;
1045: --
1046:

Line 1171: hr_utility.set_location(p_concat_segments, 692);

1167: l_api_updating := per_cpn_shd.api_updating
1168: (p_competence_id => p_competence_id
1169: ,p_object_version_number => p_object_version_number);
1170: --
1171: hr_utility.set_location(p_concat_segments, 692);
1172: hr_utility.set_location(substr(l_name,1,128), 692); --bug#2925181
1173: hr_utility.set_location(l_proc, 7);
1174: --
1175: if not l_api_updating

Line 1172: hr_utility.set_location(substr(l_name,1,128), 692); --bug#2925181

1168: (p_competence_id => p_competence_id
1169: ,p_object_version_number => p_object_version_number);
1170: --
1171: hr_utility.set_location(p_concat_segments, 692);
1172: hr_utility.set_location(substr(l_name,1,128), 692); --bug#2925181
1173: hr_utility.set_location(l_proc, 7);
1174: --
1175: if not l_api_updating
1176: then

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

1169: ,p_object_version_number => p_object_version_number);
1170: --
1171: hr_utility.set_location(p_concat_segments, 692);
1172: hr_utility.set_location(substr(l_name,1,128), 692); --bug#2925181
1173: hr_utility.set_location(l_proc, 7);
1174: --
1175: if not l_api_updating
1176: then
1177: hr_utility.set_location(l_proc, 8);

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

1173: hr_utility.set_location(l_proc, 7);
1174: --
1175: if not l_api_updating
1176: then
1177: hr_utility.set_location(l_proc, 8);
1178: --
1179: -- As this an updating API, the competence should already exist.
1180: --
1181: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

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

1177: hr_utility.set_location(l_proc, 8);
1178: --
1179: -- As this an updating API, the competence should already exist.
1180: --
1181: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1182: hr_utility.raise_error;
1183: else
1184: --
1185: hr_utility.set_location(l_proc, 9);

Line 1182: hr_utility.raise_error;

1178: --
1179: -- As this an updating API, the competence should already exist.
1180: --
1181: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1182: hr_utility.raise_error;
1183: else
1184: --
1185: hr_utility.set_location(l_proc, 9);
1186: if l_competence_definition_id is null

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

1181: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1182: hr_utility.raise_error;
1183: else
1184: --
1185: hr_utility.set_location(l_proc, 9);
1186: if l_competence_definition_id is null
1187: then
1188: l_null_ind := 0;
1189: l_competence_definition_id

Line 1210: hr_utility.set_location(l_null_ind, 693);

1206: -- p_competence_definition_id had no value when passed into program
1207: -- no value when passed into program or if l_name has no value.
1208: --
1209: --
1210: hr_utility.set_location(l_null_ind, 693);
1211: if l_null_ind = 0
1212: or l_name is null
1213: then
1214: --

Line 1254: hr_utility.set_location(l_proc, 10);

1250: ,p_ccid => l_competence_definition_id
1251: ,p_concat_segments_out => l_name
1252: );
1253: --
1254: hr_utility.set_location(l_proc, 10);
1255: end if;
1256: hr_utility.set_location(p_concat_segments, 6931);
1257: hr_utility.set_location(substr(l_name,1,128), 6932); --bug#2925181
1258: --

Line 1256: hr_utility.set_location(p_concat_segments, 6931);

1252: );
1253: --
1254: hr_utility.set_location(l_proc, 10);
1255: end if;
1256: hr_utility.set_location(p_concat_segments, 6931);
1257: hr_utility.set_location(substr(l_name,1,128), 6932); --bug#2925181
1258: --
1259: -- Process Logic
1260: --

Line 1257: hr_utility.set_location(substr(l_name,1,128), 6932); --bug#2925181

1253: --
1254: hr_utility.set_location(l_proc, 10);
1255: end if;
1256: hr_utility.set_location(p_concat_segments, 6931);
1257: hr_utility.set_location(substr(l_name,1,128), 6932); --bug#2925181
1258: --
1259: -- Process Logic
1260: --
1261: l_object_version_number := p_object_version_number;

Line 1335: hr_utility.set_location(l_proc, 11);

1331: p_information20 => p_information20
1332: );
1333: --
1334: --
1335: hr_utility.set_location(l_proc, 11);
1336: --
1337: -- MLS Processing
1338: --
1339: --

Line 1477: hr_utility.set_location(p_concat_segments, 694);

1473: p_object_version_number := l_object_version_number;
1474: p_name := l_name;
1475: p_competence_definition_id := l_competence_definition_id;
1476: --
1477: hr_utility.set_location(p_concat_segments, 694);
1478: hr_utility.set_location(' Leaving:'||l_proc, 12);
1479: exception
1480: when hr_api.validate_enabled then
1481: --

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

1474: p_name := l_name;
1475: p_competence_definition_id := l_competence_definition_id;
1476: --
1477: hr_utility.set_location(p_concat_segments, 694);
1478: hr_utility.set_location(' Leaving:'||l_proc, 12);
1479: exception
1480: when hr_api.validate_enabled then
1481: --
1482: -- As the Validate_Enabled exception has been raised

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

1509: raise;
1510: --
1511: -- End of fix.
1512: --
1513: hr_utility.set_location(' Leaving:'||l_proc, 12);
1514: --
1515: end update_competence;
1516: --
1517: --

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

1536: --
1537: --
1538: l_proc varchar2(72) := g_package||'delete_competence';
1539: begin
1540: hr_utility.set_location('Entering:'|| l_proc, 5);
1541: --
1542: -- Issue a savepoint.
1543: --
1544: savepoint delete_competence;

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

1541: --
1542: -- Issue a savepoint.
1543: --
1544: savepoint delete_competence;
1545: hr_utility.set_location(l_proc, 6);
1546: --
1547: -- Call Before Process User Hook
1548: --
1549: begin

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

1563: -- End of Before Process User hook
1564: --
1565: -- Validation in addition to Table Handlers
1566: --
1567: hr_utility.set_location(l_proc, 7);
1568: --
1569: -- Process Logic
1570: --
1571: --

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

1594: ,p_competence_id => p_competence_id
1595: ,p_object_version_number => p_object_version_number
1596: );
1597: --
1598: hr_utility.set_location(l_proc, 8);
1599: --
1600: -- Call After Process User Hook
1601: --
1602: begin

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

1619: if p_validate then
1620: raise hr_api.validate_enabled;
1621: end if;
1622: --
1623: hr_utility.set_location(' Leaving:'||l_proc, 11);
1624: exception
1625: when hr_api.validate_enabled then
1626: --
1627: -- As the Validate_Enabled exception has been raised

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

1640: raise;
1641: --
1642: -- End of fix.
1643: --
1644: hr_utility.set_location(' Leaving:'||l_proc, 12);
1645: end delete_competence;
1646: --
1647: -- ---------------------------------------------------------------------------
1648: -- |----------------< create_or_update_competence >--------------------------|

Line 1732: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');

1728: open Sel_Id;
1729: fetch Sel_Id Into l_lookup_code;
1730: if Sel_Id%notfound then
1731: close Sel_Id;
1732: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');
1733: fnd_message.set_token('MEANING',p_meaning);
1734: hr_utility.raise_error;
1735: end if;
1736: close Sel_Id;

Line 1734: hr_utility.raise_error;

1730: if Sel_Id%notfound then
1731: close Sel_Id;
1732: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');
1733: fnd_message.set_token('MEANING',p_meaning);
1734: hr_utility.raise_error;
1735: end if;
1736: close Sel_Id;
1737: --
1738: return (l_lookup_code);

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

1739: end;
1740: --
1741: Begin
1742: --
1743: hr_utility.set_location('Entering...' || l_proc,10);
1744: --
1745: -- Issue a savepoint.
1746: --
1747: savepoint create_or_update_competence;

Line 1764: hr_utility.trace('p_effective_date : ' || p_effective_date);

1760: l_effective_date := trunc(sysdate);
1761: else
1762: l_effective_date := trunc(p_effective_date);
1763: end if;
1764: hr_utility.trace('p_effective_date : ' || p_effective_date);
1765:
1766: if (p_date_from is NULL) then
1767: l_date_from := trunc(sysdate);
1768: else

Line 1771: hr_utility.trace('p_date_from : ' || p_date_from);

1767: l_date_from := trunc(sysdate);
1768: else
1769: l_date_from := trunc(p_date_from);
1770: end if;
1771: hr_utility.trace('p_date_from : ' || p_date_from);
1772:
1773: IF ( p_translated_language IS NULL AND p_source_competence_name IS NULL
1774: AND p_source_category_name IS NULL)
1775: THEN

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

1772:
1773: IF ( p_translated_language IS NULL AND p_source_competence_name IS NULL
1774: AND p_source_category_name IS NULL)
1775: THEN
1776: hr_utility.set_location(l_proc,20);
1777:
1778: if (p_category IS NOT NULL) then
1779: l_concatenate_name := p_category || '.' || p_name;
1780: l_segment1 := p_category;

Line 1797: hr_utility.trace('l_competence_id : ' || l_competence_id);

1793: l_ovn := NULL;
1794: else
1795: close csr_cpn;
1796: end if;
1797: hr_utility.trace('l_competence_id : ' || l_competence_id);
1798: hr_utility.trace('l_ovn : ' || l_ovn);
1799:
1800: if (p_rating_scale_name is not NULL) then
1801: open csr_rsc;

Line 1798: hr_utility.trace('l_ovn : ' || l_ovn);

1794: else
1795: close csr_cpn;
1796: end if;
1797: hr_utility.trace('l_competence_id : ' || l_competence_id);
1798: hr_utility.trace('l_ovn : ' || l_ovn);
1799:
1800: if (p_rating_scale_name is not NULL) then
1801: open csr_rsc;
1802: fetch csr_rsc into l_rating_scale_id;

Line 1809: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);

1805: fnd_message.set_name('PER','HR_51928_APT_RSC_NOT_EXIST');
1806: fnd_message.raise_error;
1807: end if;
1808: close csr_rsc;
1809: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);
1810: end if;
1811:
1812: hr_utility.set_location(l_proc,30);
1813:

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

1808: close csr_rsc;
1809: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);
1810: end if;
1811:
1812: hr_utility.set_location(l_proc,30);
1813:
1814: if (p_evaluation_method is not null) then
1815: l_evaluation_method := return_lookup_code
1816: (p_meaning => p_evaluation_method

Line 1820: hr_utility.trace('l_evaluation_method : ' || l_evaluation_method);

1816: (p_meaning => p_evaluation_method
1817: ,p_lookup_type => 'COMPETENCE_EVAL_TYPE'
1818: ,p_language_code => l_language_code
1819: );
1820: hr_utility.trace('l_evaluation_method : ' || l_evaluation_method);
1821: else
1822: l_evaluation_method := null;
1823: end if;
1824:

Line 1831: hr_utility.trace('l_certification_required : ' || l_certification_required);

1827: (p_meaning => p_certification_required
1828: ,p_lookup_type => 'YES_NO'
1829: ,p_language_code => l_language_code
1830: );
1831: hr_utility.trace('l_certification_required : ' || l_certification_required);
1832: else
1833: l_certification_required := 'N';
1834: end if;
1835:

Line 1842: hr_utility.trace('l_renewal_period_units : ' || l_renewal_period_units);

1838: (p_meaning => p_renewal_period_units
1839: ,p_lookup_type => 'FREQUENCY'
1840: ,p_language_code => l_language_code
1841: );
1842: hr_utility.trace('l_renewal_period_units : ' || l_renewal_period_units);
1843: else
1844: l_renewal_period_units := null;
1845: end if;
1846:

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

1846:
1847: --
1848: if ( l_competence_id is null and l_ovn is null) then
1849:
1850: hr_utility.set_location(l_proc,40);
1851:
1852: create_competence
1853: (p_effective_date => l_effective_date
1854: ,p_language_code => l_language_code

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

1871: );
1872:
1873: else
1874:
1875: hr_utility.set_location(l_proc,50);
1876:
1877: update_competence
1878: (p_effective_date => l_effective_date
1879: ,p_language_code => l_language_code

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

1901:
1902: --
1903: -- MLS update
1904: --
1905: hr_utility.set_location(l_proc,50);
1906:
1907: if (p_source_category_name IS NOT NULL) then
1908: l_concatenate_name := p_source_category_name || '.' || p_source_competence_name;
1909: else

Line 1912: hr_utility.trace('l_concatenate_name => ' || l_concatenate_name);

1908: l_concatenate_name := p_source_category_name || '.' || p_source_competence_name;
1909: else
1910: l_concatenate_name := p_source_competence_name;
1911: end if;
1912: hr_utility.trace('l_concatenate_name => ' || l_concatenate_name);
1913:
1914: open csr_cpn(l_concatenate_name);
1915: fetch csr_cpn into l_source_competence_id, l_source_ovn;
1916: if csr_cpn%NOTFOUND then

Line 1918: hr_utility.set_message(800, 'HR_449189_SOURCE_CPN_INVALID');

1914: open csr_cpn(l_concatenate_name);
1915: fetch csr_cpn into l_source_competence_id, l_source_ovn;
1916: if csr_cpn%NOTFOUND then
1917: close csr_cpn;
1918: hr_utility.set_message(800, 'HR_449189_SOURCE_CPN_INVALID');
1919: hr_utility.raise_error;
1920: else
1921: close csr_cpn;
1922: end if;

Line 1919: hr_utility.raise_error;

1915: fetch csr_cpn into l_source_competence_id, l_source_ovn;
1916: if csr_cpn%NOTFOUND then
1917: close csr_cpn;
1918: hr_utility.set_message(800, 'HR_449189_SOURCE_CPN_INVALID');
1919: hr_utility.raise_error;
1920: else
1921: close csr_cpn;
1922: end if;
1923: hr_utility.trace('l_source_competence_id : ' || l_source_competence_id);

Line 1923: hr_utility.trace('l_source_competence_id : ' || l_source_competence_id);

1919: hr_utility.raise_error;
1920: else
1921: close csr_cpn;
1922: end if;
1923: hr_utility.trace('l_source_competence_id : ' || l_source_competence_id);
1924: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
1925:
1926: l_translated_language := p_translated_language;
1927: hr_api.validate_language_code(p_language_code => l_translated_language);

Line 1924: hr_utility.trace('l_source_ovn : ' || l_source_ovn);

1920: else
1921: close csr_cpn;
1922: end if;
1923: hr_utility.trace('l_source_competence_id : ' || l_source_competence_id);
1924: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
1925:
1926: l_translated_language := p_translated_language;
1927: hr_api.validate_language_code(p_language_code => l_translated_language);
1928:

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

1939: ,p_behavioural_indicator => p_behavioural_indicator
1940: ,p_description => p_description
1941: );
1942:
1943: hr_utility.set_location(l_proc,60);
1944:
1945: --
1946: -- Call After Process User Hook
1947: --

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

2057: end;
2058:
2059: END IF;
2060: hr_competences_api.g_ignore_df := 'N';
2061: hr_utility.set_location('Leaving... ' || l_proc,70);
2062: exception
2063: when hr_api.validate_enabled then
2064: --
2065: -- As the Validate_Enabled exception has been raised

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

2078: ROLLBACK TO create_or_update_competence;
2079: --
2080: hr_competences_api.g_ignore_df := 'N';
2081: raise;
2082: hr_utility.set_location(' Leaving:'||l_proc, 80);
2083: end create_or_update_competence;
2084: --
2085: --
2086: end hr_competences_api;