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

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

20: from per_absence_attendance_types
21: where absence_attendance_type_id = p_absence_attendance_type_id;
22:
23: begin
24: hr_utility.set_location(' Entering:' || l_proc,5);
25:
26: open get_category_code(p_absence_attendance_type_id);
27: fetch get_category_code into l_absence_category ;
28: close get_category_code ;

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

29:
30: IF l_absence_category = 'S' THEN
31: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
32: IF l_legislation_code = 'GB' THEN
33: hr_utility.set_location(l_proc,10);
34:
35: populate_sickness_dates := true;
36: END IF;
37: END IF;

Line 38: hr_utility.set_location(' Leaving:' || l_proc,15);

34:
35: populate_sickness_dates := true;
36: END IF;
37: END IF;
38: hr_utility.set_location(' Leaving:' || l_proc,15);
39:
40: return populate_sickness_dates;
41: END is_gb_leg_and_category_s ;
42: --

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

167: --
168: -- Other variables
169: l_proc varchar2(72) := g_package ||'create_person_absence';
170: Begin
171: hr_utility.set_location(' Entering:' || l_proc,10);
172: --
173: -- Issue a savepoint
174: --
175: savepoint create_person_absence_swi;

Line 337: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');

333: -- messages and add them to Multiple Message List
334: --
335: if l_validate then
336: if l_dur_dys_less_warning then
337: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
338: hr_multi_message.add
339: (p_message_type => hr_multi_message.g_warning_msg
340: );
341: end if;

Line 343: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');

339: (p_message_type => hr_multi_message.g_warning_msg
340: );
341: end if;
342: if l_dur_hrs_less_warning then
343: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
344: hr_multi_message.add
345: (p_message_type => hr_multi_message.g_warning_msg
346: );
347: end if;

Line 349: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

345: (p_message_type => hr_multi_message.g_warning_msg
346: );
347: end if;
348: if l_exceeds_pto_entit_warning then
349: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
350: hr_multi_message.add
351: (p_message_type => hr_multi_message.g_warning_msg
352: );
353: end if;

Line 355: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

351: (p_message_type => hr_multi_message.g_warning_msg
352: );
353: end if;
354: if l_exceeds_run_total_warning then
355: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
356: hr_multi_message.add
357: (p_message_type => hr_multi_message.g_warning_msg
358: );
359: end if;

Line 361: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

357: (p_message_type => hr_multi_message.g_warning_msg
358: );
359: end if;
360: if l_abs_overlap_warning then
361: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
362: hr_multi_message.add
363: (p_message_type => hr_multi_message.g_warning_msg
364: );
365: end if;

Line 367: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

363: (p_message_type => hr_multi_message.g_warning_msg
364: );
365: end if;
366: if l_abs_day_after_warning then
367: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
368: hr_multi_message.add
369: (p_message_type => hr_multi_message.g_warning_msg
370: );
371: end if;

Line 377: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');

373: --
374: -- We don't raise overwritten warning from SSHR
375: --
376: --if l_dur_overwritten_warning then
377: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
378: -- hr_multi_message.add
379: -- (p_message_type => hr_multi_message.g_warning_msg
380: -- );
381: --end if; --

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

386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --

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

405: p_absence_attendance_id := null;
406: p_object_version_number := null;
407: p_occurrence := null;
408: p_return_status := hr_multi_message.get_return_status_disable;
409: hr_utility.set_location(' Leaving:' || l_proc, 30);
410: when others then
411: --
412: -- When Multiple Message Detection is enabled catch
413: -- any Application specific or other unexpected

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

416: -- error.
417: --
418: rollback to create_person_absence_swi;
419: if hr_multi_message.unexpected_error_add(l_proc) then
420: hr_utility.set_location(' Leaving:' || l_proc,40);
421: raise;
422: end if;
423: --
424: -- Reset IN OUT and set OUT parameters

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

428: p_absence_attendance_id := null;
429: p_object_version_number := null;
430: p_occurrence := null;
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc,50);
433: end create_person_absence;
434: -- ----------------------------------------------------------------------------
435: -- |-------------------------< update_person_absence >------------------------|
436: -- ----------------------------------------------------------------------------

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

553: --
554: -- Other variables
555: l_proc varchar2(72) := g_package ||'update_person_absence';
556: Begin
557: hr_utility.set_location(' Entering:' || l_proc,10);
558: --
559: -- Issue a savepoint
560: --
561: savepoint update_person_absence_swi;

Line 718: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');

714: -- messages and add them to Multiple Message List
715: --
716: if l_validate then
717: if l_dur_dys_less_warning then
718: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
719: hr_multi_message.add
720: (p_message_type => hr_multi_message.g_warning_msg
721: );
722: end if;

Line 724: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');

720: (p_message_type => hr_multi_message.g_warning_msg
721: );
722: end if;
723: if l_dur_hrs_less_warning then
724: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
725: hr_multi_message.add
726: (p_message_type => hr_multi_message.g_warning_msg
727: );
728: end if;

Line 730: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

726: (p_message_type => hr_multi_message.g_warning_msg
727: );
728: end if;
729: if l_exceeds_pto_entit_warning then
730: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
731: hr_multi_message.add
732: (p_message_type => hr_multi_message.g_warning_msg
733: );
734: end if;

Line 736: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

732: (p_message_type => hr_multi_message.g_warning_msg
733: );
734: end if;
735: if l_exceeds_run_total_warning then
736: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
737: hr_multi_message.add
738: (p_message_type => hr_multi_message.g_warning_msg
739: );
740: end if;

Line 742: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

738: (p_message_type => hr_multi_message.g_warning_msg
739: );
740: end if;
741: if l_abs_overlap_warning then
742: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
743: hr_multi_message.add
744: (p_message_type => hr_multi_message.g_warning_msg
745: );
746: end if;

Line 748: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

744: (p_message_type => hr_multi_message.g_warning_msg
745: );
746: end if;
747: if l_abs_day_after_warning then
748: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
749: hr_multi_message.add
750: (p_message_type => hr_multi_message.g_warning_msg
751: );
752: end if;

Line 757: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');

753: --
754: -- We don't raise overwritten warning from SSHR
755: --
756: --if l_dur_overwritten_warning then
757: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
758: -- hr_multi_message.add
759: -- (p_message_type => hr_multi_message.g_warning_msg
760: -- );
761: --end if; --

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

773: -- messages of any type exist in the Multiple Message List.
774: -- Also disable Multiple Message Detection.
775: --
776: p_return_status := hr_multi_message.get_return_status_disable;
777: hr_utility.set_location(' Leaving:' || l_proc,20);
778: --
779: exception
780: when hr_multi_message.error_message_exist then
781: --

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

790: p_absence_days := l_absence_days;
791: p_absence_hours := l_absence_hours;
792: p_object_version_number := l_object_version_number;
793: p_return_status := hr_multi_message.get_return_status_disable;
794: hr_utility.set_location(' Leaving:' || l_proc, 30);
795: when others then
796: --
797: -- When Multiple Message Detection is enabled catch
798: -- any Application specific or other unexpected

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

801: -- error.
802: --
803: rollback to update_person_absence_swi;
804: if hr_multi_message.unexpected_error_add(l_proc) then
805: hr_utility.set_location(' Leaving:' || l_proc,40);
806: raise;
807: end if;
808: --
809: -- Reset IN OUT and set OUT parameters

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

811: p_absence_days := l_absence_days;
812: p_absence_hours := l_absence_hours;
813: p_object_version_number := l_object_version_number;
814: p_return_status := hr_multi_message.get_return_status_disable;
815: hr_utility.set_location(' Leaving:' || l_proc,50);
816: end update_person_absence;
817: -- ----------------------------------------------------------------------------
818: -- |-------------------------< delete_person_absence >------------------------|
819: -- ----------------------------------------------------------------------------

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

833: l_proc varchar2(72) := g_package ||'delete_person_absence';
834: Begin
835:
836:
837: hr_utility.set_location(' Entering:' || l_proc,10);
838: --
839: -- Issue a savepoint
840: --
841: savepoint delete_person_absence_swi;

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

875: -- messages of any type exist in the Multiple Message List.
876: -- Also disable Multiple Message Detection.
877: --
878: p_return_status := hr_multi_message.get_return_status_disable;
879: hr_utility.set_location(' Leaving:' || l_proc,20);
880: --
881: exception
882: when hr_multi_message.error_message_exist then
883: --

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

889: --
890: -- Reset IN OUT parameters and set OUT parameters
891: --
892: p_return_status := hr_multi_message.get_return_status_disable;
893: hr_utility.set_location(' Leaving:' || l_proc, 30);
894: when others then
895: --
896: -- When Multiple Message Detection is enabled catch
897: -- any Application specific or other unexpected

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

900: -- error.
901: --
902: rollback to delete_person_absence_swi;
903: if hr_multi_message.unexpected_error_add(l_proc) then
904: hr_utility.set_location(' Leaving:' || l_proc,40);
905: raise;
906: end if;
907: --
908: -- Reset IN OUT and set OUT parameters

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

907: --
908: -- Reset IN OUT and set OUT parameters
909: --
910: p_return_status := hr_multi_message.get_return_status_disable;
911: hr_utility.set_location(' Leaving:' || l_proc,50);
912: end delete_person_absence;
913:
914:
915: -- ----------------------------------------------------------------------------

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

951: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
952: --
953: --
954: Begin
955: hr_utility.set_location(' Entering:' || l_proc,10);
956: --
957: -- Get language
958: select userenv('LANG') into l_language from dual;
959: --

Line 984: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);

980: close csr_get_doc_tl;
981: raise data_error;
982: END IF;
983:
984: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
985: -- Now, lock the rows.
986: fnd_attached_documents_pkg.lock_row
987: (x_rowid => p_rowid
988: ,x_attached_document_id =>

Line 1057: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);

1053:
1054: -- Update document to fnd_attached_documents, fnd_documents,
1055: -- fnd_documents_tl
1056: --
1057: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1058: fnd_attached_documents_pkg.update_row
1059: (x_rowid => p_rowid
1060: ,x_attached_document_id =>
1061: l_attached_doc_pre_upd.attached_document_id

Line 1128: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);

1124: ,x_url => l_doc_pre_upd.url
1125: ,x_title => l_doc_tl_pre_upd.title
1126: );
1127:
1128: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1129: hr_utility.set_location(' Leaving:' || l_proc,50);
1130:
1131: EXCEPTION
1132: when others then

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

1125: ,x_title => l_doc_tl_pre_upd.title
1126: );
1127:
1128: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1129: hr_utility.set_location(' Leaving:' || l_proc,50);
1130:
1131: EXCEPTION
1132: when others then
1133: hr_utility.set_location(' Error in :' || l_proc,60);

Line 1133: hr_utility.set_location(' Error in :' || l_proc,60);

1129: hr_utility.set_location(' Leaving:' || l_proc,50);
1130:
1131: EXCEPTION
1132: when others then
1133: hr_utility.set_location(' Error in :' || l_proc,60);
1134: raise;
1135: --
1136: End update_attachment;
1137:

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

1158: FROM fnd_attached_documents
1159: WHERE attached_document_id = X_attached_document_id;
1160: --
1161: Begin
1162: hr_utility.set_location(' Entering:' || l_proc,10);
1163: --
1164: -- Issue a savepoint
1165: --
1166: savepoint attachments_person_absence_swi;

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

1186: end loop;
1187:
1188: p_return_status := hr_multi_message.get_return_status_disable;
1189:
1190: hr_utility.set_location(' Leaving:' || l_proc,20);
1191: --
1192: exception
1193: when others then
1194: --

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

1199: -- error.
1200: --
1201: rollback to attachments_person_absence_swi;
1202: if hr_multi_message.unexpected_error_add(l_proc) then
1203: hr_utility.set_location(' Leaving:' || l_proc,40);
1204: raise;
1205: end if;
1206: --
1207: -- Reset IN OUT and set OUT parameters

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

1206: --
1207: -- Reset IN OUT and set OUT parameters
1208: p_return_status := hr_multi_message.get_return_status_disable;
1209:
1210: hr_utility.set_location(' Leaving:' || l_proc,50);
1211: end merge_attachments;
1212:
1213:
1214: -- ----------------------------------------------------------------------------

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

1237: lv_action varchar2(30);
1238:
1239: BEGIN
1240:
1241: hr_utility.set_location(' Entering:' || l_proc,10);
1242: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1243: l_parser := xmlparser.newParser;
1244: xmlparser.ParseCLOB(l_parser,p_document);
1245: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

1238:
1239: BEGIN
1240:
1241: hr_utility.set_location(' Entering:' || l_proc,10);
1242: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1243: l_parser := xmlparser.newParser;
1244: xmlparser.ParseCLOB(l_parser,p_document);
1245: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1246:

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

1243: l_parser := xmlparser.newParser;
1244: xmlparser.ParseCLOB(l_parser,p_document);
1245: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1246:
1247: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1248:
1249: l_commitElement := xmldom.makeElement(l_CommitNode);
1250: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1251: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

1470: l_return_status);
1471: end if;
1472:
1473: p_return_status := l_return_status;
1474: hr_utility.set_location('Exiting:' || l_proc,40);
1475:
1476: END process_api;
1477:
1478: end hr_person_absence_swi;