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

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

82: l_competence_element_id number;
83: l_proc varchar2(72) := g_package ||'create_competence_element';
84:
85: Begin
86: hr_utility.set_location(' Entering:' || l_proc,10);
87:
88: g_session_id := NULL;
89: g_competence_element_id := NULL;
90: --

Line 192: hr_utility.set_location(' Leaving:' || l_proc,20);

188: -- messages of any type exist in the Multiple Message List.
189: -- Also disable Multiple Message Detection.
190: --
191: p_return_status := hr_multi_message.get_return_status_disable;
192: hr_utility.set_location(' Leaving:' || l_proc,20);
193: --
194: exception
195: when hr_multi_message.error_message_exist then
196: --

Line 207: hr_utility.set_location(' Leaving:' || l_proc, 30);

203: -- Reset IN OUT parameters and set OUT parameters
204: --
205: p_object_version_number := null;
206: p_return_status := hr_multi_message.get_return_status_disable;
207: hr_utility.set_location(' Leaving:' || l_proc, 30);
208:
209: when others then
210: --
211: -- When Multiple Message Detection is enabled catch

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

215: -- error.
216: --
217: rollback to create_competence_element_swi;
218: if hr_multi_message.unexpected_error_add(l_proc) then
219: hr_utility.set_location(' Leaving:' || l_proc,40);
220: raise;
221: end if;
222:
223:

Line 229: hr_utility.set_location(' Leaving:' || l_proc,50);

225: -- Reset IN OUT and set OUT parameters
226: --
227: p_object_version_number := null;
228: p_return_status := hr_multi_message.get_return_status_disable;
229: hr_utility.set_location(' Leaving:' || l_proc,50);
230: end create_competence_element;
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------< copy_competencies >--------------------------|
233: -- ----------------------------------------------------------------------------

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

246: --
247: -- Other variables
248: l_proc varchar2(72) := g_package ||'copy_competencies';
249: Begin
250: hr_utility.set_location(' Entering:' || l_proc,10);
251: --
252: -- Issue a savepoint
253: --
254: savepoint copy_competencies_swi;

Line 293: hr_utility.set_location(' Leaving:' || l_proc,20);

289: -- messages of any type exist in the Multiple Message List.
290: -- Also disable Multiple Message Detection.
291: --
292: p_return_status := hr_multi_message.get_return_status_disable;
293: hr_utility.set_location(' Leaving:' || l_proc,20);
294: --
295: exception
296: when hr_multi_message.error_message_exist then
297: --

Line 307: hr_utility.set_location(' Leaving:' || l_proc, 30);

303: --
304: -- Reset IN OUT parameters and set OUT parameters
305: --
306: p_return_status := hr_multi_message.get_return_status_disable;
307: hr_utility.set_location(' Leaving:' || l_proc, 30);
308: when others then
309: --
310: -- When Multiple Message Detection is enabled catch
311: -- any Application specific or other unexpected

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

314: -- error.
315: --
316: rollback to copy_competencies_swi;
317: if hr_multi_message.unexpected_error_add(l_proc) then
318: hr_utility.set_location(' Leaving:' || l_proc,40);
319: raise;
320: end if;
321: --
322: -- Reset IN OUT and set OUT parameters

Line 325: hr_utility.set_location(' Leaving:' || l_proc,50);

321: --
322: -- Reset IN OUT and set OUT parameters
323: --
324: p_return_status := hr_multi_message.get_return_status_disable;
325: hr_utility.set_location(' Leaving:' || l_proc,50);
326: end copy_competencies;
327: -- ----------------------------------------------------------------------------
328: -- |-----------------------< delete_competence_element >----------------------|
329: -- ----------------------------------------------------------------------------

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

347: select object_version_number
348: from per_competence_elements
349: where competence_element_id = p_competence_element_id;
350: Begin
351: hr_utility.set_location(' Entering:' || l_proc,10);
352:
353: g_session_id := NULL;
354: g_competence_element_id := NULL;
355: --

Line 403: hr_utility.set_location(' Leaving:' || l_proc,20);

399: -- messages of any type exist in the Multiple Message List.
400: -- Also disable Multiple Message Detection.
401: --
402: p_return_status := hr_multi_message.get_return_status_disable;
403: hr_utility.set_location(' Leaving:' || l_proc,20);
404: --
405: exception
406: when hr_multi_message.error_message_exist then
407: --

Line 417: hr_utility.set_location(' Leaving:' || l_proc, 30);

413: --
414: -- Reset IN OUT parameters and set OUT parameters
415: --
416: p_return_status := hr_multi_message.get_return_status_disable;
417: hr_utility.set_location(' Leaving:' || l_proc, 30);
418: when others then
419: --
420: -- When Multiple Message Detection is enabled catch
421: -- any Application specific or other unexpected

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

424: -- error.
425: --
426: rollback to delete_competence_element_swi;
427: if hr_multi_message.unexpected_error_add(l_proc) then
428: hr_utility.set_location(' Leaving:' || l_proc,40);
429: raise;
430: end if;
431: --
432: -- Reset IN OUT and set OUT parameters

Line 435: hr_utility.set_location(' Leaving:' || l_proc,50);

431: --
432: -- Reset IN OUT and set OUT parameters
433: --
434: p_return_status := hr_multi_message.get_return_status_disable;
435: hr_utility.set_location(' Leaving:' || l_proc,50);
436: end delete_competence_element;
437: -- ----------------------------------------------------------------------------
438: -- |---------------------< maintain_student_comp_element >--------------------|
439: -- ----------------------------------------------------------------------------

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

462: --
463: -- Other variables
464: l_proc varchar2(72) := g_package ||'maintain_student_comp_element';
465: Begin
466: hr_utility.set_location(' Entering:' || l_proc,10);
467: --
468: -- Issue a savepoint
469: --
470: savepoint maintain_student_comp_ele_swi;

Line 519: hr_utility.set_location(' Leaving:' || l_proc,20);

515: -- messages of any type exist in the Multiple Message List.
516: -- Also disable Multiple Message Detection.
517: --
518: p_return_status := hr_multi_message.get_return_status_disable;
519: hr_utility.set_location(' Leaving:' || l_proc,20);
520: --
521: exception
522: when hr_multi_message.error_message_exist then
523: --

Line 534: hr_utility.set_location(' Leaving:' || l_proc, 30);

530: -- Reset IN OUT parameters and set OUT parameters
531: --
532: p_competence_created := null;
533: p_return_status := hr_multi_message.get_return_status_disable;
534: hr_utility.set_location(' Leaving:' || l_proc, 30);
535: when others then
536: --
537: -- When Multiple Message Detection is enabled catch
538: -- any Application specific or other unexpected

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

541: -- error.
542: --
543: rollback to maintain_student_comp_ele_swi;
544: if hr_multi_message.unexpected_error_add(l_proc) then
545: hr_utility.set_location(' Leaving:' || l_proc,40);
546: raise;
547: end if;
548: --
549: -- Reset IN OUT and set OUT parameters

Line 553: hr_utility.set_location(' Leaving:' || l_proc,50);

549: -- Reset IN OUT and set OUT parameters
550: --
551: p_competence_created := null;
552: p_return_status := hr_multi_message.get_return_status_disable;
553: hr_utility.set_location(' Leaving:' || l_proc,50);
554: end maintain_student_comp_element;
555:
556: -- ----------------------------------------------------------------------------
557: -- |-----------------------< get_non_gmisc_value >----------------------|

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

673: l_proc varchar2(72) := g_package ||'update_competence_element';
674:
675:
676: Begin
677: hr_utility.set_location(' Entering:' || l_proc,10);
678:
679: g_session_id := NULL;
680: g_competence_element_id := NULL;
681: --

Line 945: hr_utility.set_location(' Leaving:' || l_proc,20);

941: --
942: if l_validate then
943: raise hr_api.validate_enabled;
944: end if;
945: hr_utility.set_location(' Leaving:' || l_proc,20);
946: --
947: exception
948: when hr_multi_message.error_message_exist then
949: --

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

956: -- Reset IN OUT parameters and set OUT parameters
957: --
958: p_object_version_number := l_object_version_number;
959: p_return_status := hr_multi_message.get_return_status_disable;
960: hr_utility.set_location(' Leaving:' || l_proc, 30);
961: when hr_api.validate_enabled then
962: --
963: -- As the Validate_Enabled exception has been raised
964: -- we must rollback to the savepoint

Line 972: hr_utility.set_location(' Leaving:' || l_proc, 35);

968: -- Reset IN OUT parameters and set OUT parameters
969: --
970: p_object_version_number := l_object_version_number;
971: p_return_status := hr_multi_message.get_return_status_disable;
972: hr_utility.set_location(' Leaving:' || l_proc, 35);
973: when others then
974: --
975: -- When Multiple Message Detection is enabled catch
976: -- any Application specific or other unexpected

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

979: -- error.
980: --
981: rollback to update_competence_element_swi;
982: if hr_multi_message.unexpected_error_add(l_proc) then
983: hr_utility.set_location(' Leaving:' || l_proc,40);
984: raise;
985: end if;
986: --
987: -- Reset IN OUT and set OUT parameters

Line 991: hr_utility.set_location(' Leaving:' || l_proc,50);

987: -- Reset IN OUT and set OUT parameters
988: --
989: p_object_version_number := l_object_version_number;
990: p_return_status := hr_multi_message.get_return_status_disable;
991: hr_utility.set_location(' Leaving:' || l_proc,50);
992: end update_competence_element;
993: -- ----------------------------------------------------------------------------
994: -- |------------------------< update_delivered_dates >------------------------|
995: -- ----------------------------------------------------------------------------

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

1010: --
1011: -- Other variables
1012: l_proc varchar2(72) := g_package ||'update_delivered_dates';
1013: Begin
1014: hr_utility.set_location(' Entering:' || l_proc,10);
1015: --
1016: -- Issue a savepoint
1017: --
1018: savepoint update_delivered_dates_swi;

Line 1059: hr_utility.set_location(' Leaving:' || l_proc,20);

1055: -- messages of any type exist in the Multiple Message List.
1056: -- Also disable Multiple Message Detection.
1057: --
1058: p_return_status := hr_multi_message.get_return_status_disable;
1059: hr_utility.set_location(' Leaving:' || l_proc,20);
1060: --
1061: exception
1062: when hr_multi_message.error_message_exist then
1063: --

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

1069: --
1070: -- Reset IN OUT parameters and set OUT parameters
1071: --
1072: p_return_status := hr_multi_message.get_return_status_disable;
1073: hr_utility.set_location(' Leaving:' || l_proc, 30);
1074: when others then
1075: --
1076: -- When Multiple Message Detection is enabled catch
1077: -- any Application specific or other unexpected

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

1080: -- error.
1081: --
1082: rollback to update_delivered_dates_swi;
1083: if hr_multi_message.unexpected_error_add(l_proc) then
1084: hr_utility.set_location(' Leaving:' || l_proc,40);
1085: raise;
1086: end if;
1087: --
1088: -- Reset IN OUT and set OUT parameters

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

1087: --
1088: -- Reset IN OUT and set OUT parameters
1089: --
1090: p_return_status := hr_multi_message.get_return_status_disable;
1091: hr_utility.set_location(' Leaving:' || l_proc,50);
1092: end update_delivered_dates;
1093: -- ----------------------------------------------------------------------------
1094: -- |---------------------< update_personal_comp_element >---------------------|
1095: -- ----------------------------------------------------------------------------

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

1140: --
1141: -- Other variables
1142: l_proc varchar2(72) := g_package ||'update_personal_comp_element';
1143: Begin
1144: hr_utility.set_location(' Entering:' || l_proc,10);
1145: --
1146: -- Issue a savepoint
1147: --
1148: savepoint update_personal_comp_ele_swi;

Line 1219: hr_utility.set_location(' Leaving:' || l_proc,20);

1215: -- messages of any type exist in the Multiple Message List.
1216: -- Also disable Multiple Message Detection.
1217: --
1218: p_return_status := hr_multi_message.get_return_status_disable;
1219: hr_utility.set_location(' Leaving:' || l_proc,20);
1220: --
1221: exception
1222: when hr_multi_message.error_message_exist then
1223: --

Line 1236: hr_utility.set_location(' Leaving:' || l_proc, 30);

1232: p_object_version_number := l_object_version_number;
1233: p_ins_ovn := null;
1234: p_ins_comp_id := null;
1235: p_return_status := hr_multi_message.get_return_status_disable;
1236: hr_utility.set_location(' Leaving:' || l_proc, 30);
1237: when others then
1238: --
1239: -- When Multiple Message Detection is enabled catch
1240: -- any Application specific or other unexpected

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

1243: -- error.
1244: --
1245: rollback to update_personal_comp_ele_swi;
1246: if hr_multi_message.unexpected_error_add(l_proc) then
1247: hr_utility.set_location(' Leaving:' || l_proc,40);
1248: raise;
1249: end if;
1250: --
1251: -- Reset IN OUT and set OUT parameters

Line 1257: hr_utility.set_location(' Leaving:' || l_proc,50);

1253: p_object_version_number := l_object_version_number;
1254: p_ins_ovn := null;
1255: p_ins_comp_id := null;
1256: p_return_status := hr_multi_message.get_return_status_disable;
1257: hr_utility.set_location(' Leaving:' || l_proc,50);
1258: end update_personal_comp_element;
1259:
1260: -- ----------------------------------------------------------------------------
1261: -- |---------------------------< process_api >--------------------------------|

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

1290: l_attach_status varchar2(80);
1291:
1292: BEGIN
1293:
1294: hr_utility.set_location(' Entering:' || l_proc,10);
1295: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1296: l_parser := xmlparser.newParser;
1297: xmlparser.ParseCLOB(l_parser,p_document);
1298: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 1295: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

1291:
1292: BEGIN
1293:
1294: hr_utility.set_location(' Entering:' || l_proc,10);
1295: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1296: l_parser := xmlparser.newParser;
1297: xmlparser.ParseCLOB(l_parser,p_document);
1298: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1299:

Line 1300: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

1296: l_parser := xmlparser.newParser;
1297: xmlparser.ParseCLOB(l_parser,p_document);
1298: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1299:
1300: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1301:
1302: l_commitElement := xmldom.makeElement(l_CommitNode);
1303: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1304: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

Line 1457: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' ||l_proc, 30);

1453: OPEN get_person_for_comp_element(hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId'));
1454: FETCH get_person_for_comp_element INTO l_person_id;
1455: CLOSE get_person_for_comp_element;
1456:
1457: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' ||l_proc, 30);
1458:
1459: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
1460: ,p_dest_pk1_value => l_person_id
1461: ,p_return_status => l_attach_status);

Line 1463: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 35);

1459: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
1460: ,p_dest_pk1_value => l_person_id
1461: ,p_return_status => l_attach_status);
1462:
1463: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 35);
1464:
1465: hr_utility.set_location('Exiting:' || l_proc,40);
1466:
1467: END process_api;

Line 1465: hr_utility.set_location('Exiting:' || l_proc,40);

1461: ,p_return_status => l_attach_status);
1462:
1463: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 35);
1464:
1465: hr_utility.set_location('Exiting:' || l_proc,40);
1466:
1467: END process_api;
1468: end hr_competence_element_swi;