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 40: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

36:
37:
38: exception
39: when others then
40: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
41: Wf_Core.Context(g_package, c_proc, p_transaction_id);
42: -- raise;
43: return null;
44: end getEndDate;

Line 53: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

49: c_proc constant varchar2(30) := 'getStartDate';
50: lv_startDate hr_api_transaction_steps.Information1%type;
51: begin
52:
53: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
54:
55:
56: if(p_transaction_id is not null) then
57: begin

Line 75: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

71: else
72: return null;
73: end if;
74:
75: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
76:
77:
78: exception
79: when others then

Line 80: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

76:
77:
78: exception
79: when others then
80: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
81: Wf_Core.Context(g_package, c_proc, p_transaction_id);
82: -- raise;
83: return null;
84: end getStartDate;

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

143:
144: BEGIN
145: --
146:
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148:
149: --
150: -- check if this absence overlaps another absence for the same person.
151: --

Line 176: hr_utility.trace(' .chk_overlap: ' || SQLERRM );

172:
173: --
174: EXCEPTION
175: WHEN OTHERS THEN
176: hr_utility.trace(' .chk_overlap: ' || SQLERRM );
177: hr_utility.set_location('Leaving:'|| l_proc, 555);
178: raise ;
179: end chk_overlap;
180:

Line 177: hr_utility.set_location('Leaving:'|| l_proc, 555);

173: --
174: EXCEPTION
175: WHEN OTHERS THEN
176: hr_utility.trace(' .chk_overlap: ' || SQLERRM );
177: hr_utility.set_location('Leaving:'|| l_proc, 555);
178: raise ;
179: end chk_overlap;
180:
181: function is_gb_leg_and_category_s(p_absence_attendance_type_id IN NUMBER ,

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

193: from per_absence_attendance_types
194: where absence_attendance_type_id = p_absence_attendance_type_id;
195:
196: begin
197: hr_utility.set_location(' Entering:' || l_proc,5);
198:
199: open get_category_code(p_absence_attendance_type_id);
200: fetch get_category_code into l_absence_category ;
201: close get_category_code ;

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

202:
203: IF l_absence_category = 'S' THEN
204: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
205: IF l_legislation_code = 'GB' THEN
206: hr_utility.set_location(l_proc,10);
207:
208: populate_sickness_dates := true;
209: END IF;
210: END IF;

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

207:
208: populate_sickness_dates := true;
209: END IF;
210: END IF;
211: hr_utility.set_location(' Leaving:' || l_proc,15);
212:
213: return populate_sickness_dates;
214: END is_gb_leg_and_category_s ;
215: --

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

342: --
343: -- Other variables
344: l_proc varchar2(72) := g_package ||'create_person_absence';
345: Begin
346: hr_utility.set_location(' Entering:' || l_proc,10);
347: --
348: -- Issue a savepoint
349: --
350: savepoint create_person_absence_swi;

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

519: -- messages and add them to Multiple Message List
520: --
521: if l_validate then
522: if l_dur_dys_less_warning then
523: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
524: hr_multi_message.add
525: (p_message_type => hr_multi_message.g_warning_msg
526: );
527: end if;

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

525: (p_message_type => hr_multi_message.g_warning_msg
526: );
527: end if;
528: if l_dur_hrs_less_warning then
529: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
530: hr_multi_message.add
531: (p_message_type => hr_multi_message.g_warning_msg
532: );
533: end if;

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

531: (p_message_type => hr_multi_message.g_warning_msg
532: );
533: end if;
534: if l_exceeds_pto_entit_warning then
535: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
536: hr_multi_message.add
537: (p_message_type => hr_multi_message.g_warning_msg
538: );
539: end if;

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

537: (p_message_type => hr_multi_message.g_warning_msg
538: );
539: end if;
540: if l_exceeds_run_total_warning then
541: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
542: hr_multi_message.add
543: (p_message_type => hr_multi_message.g_warning_msg
544: );
545: end if;

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

543: (p_message_type => hr_multi_message.g_warning_msg
544: );
545: end if;
546: if l_abs_overlap_warning then
547: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
548: hr_multi_message.add
549: (p_message_type => hr_multi_message.g_warning_msg
550: );
551: end if;

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

549: (p_message_type => hr_multi_message.g_warning_msg
550: );
551: end if;
552: if l_abs_day_after_warning then
553: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
554: hr_multi_message.add
555: (p_message_type => hr_multi_message.g_warning_msg
556: );
557: end if;

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

563: l_dur_dys_less_warning OR
564: l_abs_overlap_warning OR
565: l_abs_day_after_warning) then
566:
567: hr_utility.set_location(l_proc, 40);
568:
569: else
570: l_abs_overlap_warning := chk_overlap(p_person_id,p_business_group_id,nvl(p_date_start,p_date_projected_start),nvl(p_date_end,p_date_projected_end),nvl(p_time_start,p_time_projected_start),nvl(p_time_end,p_time_projected_end));
571:

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

569: else
570: l_abs_overlap_warning := chk_overlap(p_person_id,p_business_group_id,nvl(p_date_start,p_date_projected_start),nvl(p_date_end,p_date_projected_end),nvl(p_time_start,p_time_projected_start),nvl(p_time_end,p_time_projected_end));
571:
572: if l_abs_overlap_warning then
573: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
574: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);
575: end if;
576: end if;
577:

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

579: --
580: -- We don't raise overwritten warning from SSHR
581: --
582: --if l_dur_overwritten_warning then
583: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
584: -- hr_multi_message.add
585: -- (p_message_type => hr_multi_message.g_warning_msg
586: -- );
587: --end if; --

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

592: -- messages of any type exist in the Multiple Message List.
593: -- Also disable Multiple Message Detection.
594: --
595: p_return_status := hr_multi_message.get_return_status_disable;
596: hr_utility.set_location(' Leaving:' || l_proc,20);
597: --
598: exception
599: when hr_multi_message.error_message_exist then
600: --

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

611: p_absence_attendance_id := null;
612: p_object_version_number := null;
613: p_occurrence := null;
614: p_return_status := hr_multi_message.get_return_status_disable;
615: hr_utility.set_location(' Leaving:' || l_proc, 30);
616: when others then
617: --
618: -- When Multiple Message Detection is enabled catch
619: -- any Application specific or other unexpected

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

622: -- error.
623: --
624: rollback to create_person_absence_swi;
625: if hr_multi_message.unexpected_error_add(l_proc) then
626: hr_utility.set_location(' Leaving:' || l_proc,40);
627: raise;
628: end if;
629: l_sqlerrm := sqlerrm;
630: l_error_text := hr_utility.get_message;

Line 630: l_error_text := hr_utility.get_message;

626: hr_utility.set_location(' Leaving:' || l_proc,40);
627: raise;
628: end if;
629: l_sqlerrm := sqlerrm;
630: l_error_text := hr_utility.get_message;
631: if l_error_text is null then
632: l_error_text := fnd_message.get;
633: end if;
634:

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

632: l_error_text := fnd_message.get;
633: end if;
634:
635: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
636: hr_utility.set_location(' Leaving:' || l_proc,45);
637: raise;
638: end if;
639: --
640: -- Reset IN OUT and set OUT parameters

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

644: p_absence_attendance_id := null;
645: p_object_version_number := null;
646: p_occurrence := null;
647: p_return_status := hr_multi_message.get_return_status_disable;
648: hr_utility.set_location(' Leaving:' || l_proc,50);
649: end create_person_absence;
650: -- ----------------------------------------------------------------------------
651: -- |-------------------------< update_person_absence >------------------------|
652: -- ----------------------------------------------------------------------------

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

784: l_sqlerrm varchar2(2000);
785: l_date_start Date;
786:
787: Begin
788: hr_utility.set_location(' Entering:' || l_proc,10);
789: --
790: -- Issue a savepoint
791: --
792: savepoint update_person_absence_swi;

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

951: -- messages and add them to Multiple Message List
952: --
953: if l_validate then
954: if l_dur_dys_less_warning then
955: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
956: hr_multi_message.add
957: (p_message_type => hr_multi_message.g_warning_msg
958: );
959: end if;

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

957: (p_message_type => hr_multi_message.g_warning_msg
958: );
959: end if;
960: if l_dur_hrs_less_warning then
961: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
962: hr_multi_message.add
963: (p_message_type => hr_multi_message.g_warning_msg
964: );
965: end if;

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

963: (p_message_type => hr_multi_message.g_warning_msg
964: );
965: end if;
966: if l_exceeds_pto_entit_warning then
967: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
968: hr_multi_message.add
969: (p_message_type => hr_multi_message.g_warning_msg
970: );
971: end if;

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

969: (p_message_type => hr_multi_message.g_warning_msg
970: );
971: end if;
972: if l_exceeds_run_total_warning then
973: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
974: hr_multi_message.add
975: (p_message_type => hr_multi_message.g_warning_msg
976: );
977: end if;

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

975: (p_message_type => hr_multi_message.g_warning_msg
976: );
977: end if;
978: if l_abs_overlap_warning then
979: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
980: hr_multi_message.add
981: (p_message_type => hr_multi_message.g_warning_msg
982: );
983: end if;

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

981: (p_message_type => hr_multi_message.g_warning_msg
982: );
983: end if;
984: if l_abs_day_after_warning then
985: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
986: hr_multi_message.add
987: (p_message_type => hr_multi_message.g_warning_msg
988: );
989: end if;

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

990: --
991: -- We don't raise overwritten warning from SSHR
992: --
993: --if l_dur_overwritten_warning then
994: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
995: -- hr_multi_message.add
996: -- (p_message_type => hr_multi_message.g_warning_msg
997: -- );
998: --end if; --

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

1009: l_abs_overlap_warning OR
1010: l_abs_day_after_warning OR
1011: l_del_element_entry_warning) then
1012:
1013: hr_utility.set_location(l_proc, 40);
1014:
1015: else
1016:
1017: begin

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

1028:
1029:
1030:
1031: if l_abs_overlap_warning then
1032: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
1033: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);
1034: end if;
1035: end if;
1036:

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

1042: -- messages of any type exist in the Multiple Message List.
1043: -- Also disable Multiple Message Detection.
1044: --
1045: p_return_status := hr_multi_message.get_return_status_disable;
1046: hr_utility.set_location(' Leaving:' || l_proc,20);
1047: --
1048: exception
1049: when hr_multi_message.error_message_exist then
1050: --

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

1059: p_absence_days := l_absence_days;
1060: p_absence_hours := l_absence_hours;
1061: p_object_version_number := l_object_version_number;
1062: p_return_status := hr_multi_message.get_return_status_disable;
1063: hr_utility.set_location(' Leaving:' || l_proc, 30);
1064: when others then
1065: --
1066: -- When Multiple Message Detection is enabled catch
1067: -- any Application specific or other unexpected

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

1070: -- error.
1071: --
1072: rollback to update_person_absence_swi;
1073: if hr_multi_message.unexpected_error_add(l_proc) then
1074: hr_utility.set_location(' Leaving:' || l_proc,40);
1075: raise;
1076: end if;
1077: l_sqlerrm := sqlerrm;
1078: l_error_text := hr_utility.get_message;

Line 1078: l_error_text := hr_utility.get_message;

1074: hr_utility.set_location(' Leaving:' || l_proc,40);
1075: raise;
1076: end if;
1077: l_sqlerrm := sqlerrm;
1078: l_error_text := hr_utility.get_message;
1079: if l_error_text is null then
1080: l_error_text := fnd_message.get;
1081: end if;
1082:

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

1080: l_error_text := fnd_message.get;
1081: end if;
1082:
1083: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
1084: hr_utility.set_location(' Leaving:' || l_proc,45);
1085: raise;
1086: end if;
1087:
1088: --

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

1091: p_absence_days := l_absence_days;
1092: p_absence_hours := l_absence_hours;
1093: p_object_version_number := l_object_version_number;
1094: p_return_status := hr_multi_message.get_return_status_disable;
1095: hr_utility.set_location(' Leaving:' || l_proc,50);
1096: end update_person_absence;
1097: -- ----------------------------------------------------------------------------
1098: -- |-------------------------< delete_person_absence >------------------------|
1099: -- ----------------------------------------------------------------------------

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

1113: l_proc varchar2(72) := g_package ||'delete_person_absence';
1114: Begin
1115:
1116:
1117: hr_utility.set_location(' Entering:' || l_proc,10);
1118: --
1119: -- Issue a savepoint
1120: --
1121: savepoint delete_person_absence_swi;

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

1155: -- messages of any type exist in the Multiple Message List.
1156: -- Also disable Multiple Message Detection.
1157: --
1158: p_return_status := hr_multi_message.get_return_status_disable;
1159: hr_utility.set_location(' Leaving:' || l_proc,20);
1160: --
1161: exception
1162: when hr_multi_message.error_message_exist then
1163: --

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

1169: --
1170: -- Reset IN OUT parameters and set OUT parameters
1171: --
1172: p_return_status := hr_multi_message.get_return_status_disable;
1173: hr_utility.set_location(' Leaving:' || l_proc, 30);
1174: when others then
1175: --
1176: -- When Multiple Message Detection is enabled catch
1177: -- any Application specific or other unexpected

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

1180: -- error.
1181: --
1182: rollback to delete_person_absence_swi;
1183: if hr_multi_message.unexpected_error_add(l_proc) then
1184: hr_utility.set_location(' Leaving:' || l_proc,40);
1185: raise;
1186: end if;
1187: --
1188: -- Reset IN OUT and set OUT parameters

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

1187: --
1188: -- Reset IN OUT and set OUT parameters
1189: --
1190: p_return_status := hr_multi_message.get_return_status_disable;
1191: hr_utility.set_location(' Leaving:' || l_proc,50);
1192: end delete_person_absence;
1193:
1194:
1195: -- ----------------------------------------------------------------------------

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

1231: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
1232: --
1233: --
1234: Begin
1235: hr_utility.set_location(' Entering:' || l_proc,10);
1236: --
1237: -- Get language
1238: select userenv('LANG') into l_language from dual;
1239: --

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

1260: close csr_get_doc_tl;
1261: raise data_error;
1262: END IF;
1263:
1264: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1265: -- Now, lock the rows.
1266: fnd_attached_documents_pkg.lock_row
1267: (x_rowid => p_rowid
1268: ,x_attached_document_id =>

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

1333:
1334: -- Update document to fnd_attached_documents, fnd_documents,
1335: -- fnd_documents_tl
1336: --
1337: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1338: fnd_attached_documents_pkg.update_row
1339: (x_rowid => p_rowid
1340: ,x_attached_document_id =>
1341: l_attached_doc_pre_upd.attached_document_id

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

1404: ,x_url => l_doc_pre_upd.url
1405: ,x_title => l_doc_tl_pre_upd.title
1406: );
1407:
1408: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1409: hr_utility.set_location(' Leaving:' || l_proc,50);
1410:
1411: EXCEPTION
1412: when others then

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

1405: ,x_title => l_doc_tl_pre_upd.title
1406: );
1407:
1408: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1409: hr_utility.set_location(' Leaving:' || l_proc,50);
1410:
1411: EXCEPTION
1412: when others then
1413: hr_utility.set_location(' Error in :' || l_proc,60);

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

1409: hr_utility.set_location(' Leaving:' || l_proc,50);
1410:
1411: EXCEPTION
1412: when others then
1413: hr_utility.set_location(' Error in :' || l_proc,60);
1414: raise;
1415: --
1416: End update_attachment;
1417:

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

1438: FROM fnd_attached_documents
1439: WHERE attached_document_id = X_attached_document_id;
1440: --
1441: Begin
1442: hr_utility.set_location(' Entering:' || l_proc,10);
1443: --
1444: -- Issue a savepoint
1445: --
1446: savepoint attachments_person_absence_swi;

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

1466: end loop;
1467:
1468: p_return_status := hr_multi_message.get_return_status_disable;
1469:
1470: hr_utility.set_location(' Leaving:' || l_proc,20);
1471: --
1472: exception
1473: when others then
1474: --

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

1479: -- error.
1480: --
1481: rollback to attachments_person_absence_swi;
1482: if hr_multi_message.unexpected_error_add(l_proc) then
1483: hr_utility.set_location(' Leaving:' || l_proc,40);
1484: raise;
1485: end if;
1486: --
1487: -- Reset IN OUT and set OUT parameters

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

1486: --
1487: -- Reset IN OUT and set OUT parameters
1488: p_return_status := hr_multi_message.get_return_status_disable;
1489:
1490: hr_utility.set_location(' Leaving:' || l_proc,50);
1491: end merge_attachments;
1492:
1493:
1494: -- ----------------------------------------------------------------------------

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

1531:
1532:
1533: BEGIN
1534:
1535: hr_utility.set_location(' Entering:' || l_proc,10);
1536: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1537: savepoint absence_process_api;
1538: l_parser := xmlparser.newParser;
1539: xmlparser.ParseCLOB(l_parser,p_document);

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

1532:
1533: BEGIN
1534:
1535: hr_utility.set_location(' Entering:' || l_proc,10);
1536: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1537: savepoint absence_process_api;
1538: l_parser := xmlparser.newParser;
1539: xmlparser.ParseCLOB(l_parser,p_document);
1540: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

1538: l_parser := xmlparser.newParser;
1539: xmlparser.ParseCLOB(l_parser,p_document);
1540: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1541:
1542: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1543:
1544: l_commitElement := xmldom.makeElement(l_CommitNode);
1545: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1546: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

Line 1779: hr_utility.trace('msg count:'||l_msg_count);

1775:
1776: --Fix for Bug 14560350 start
1777: l_msg_count := fnd_msg_pub.Count_Msg;
1778: lw_msg_count := 0;
1779: hr_utility.trace('msg count:'||l_msg_count);
1780:
1781: FOR i IN 1 .. l_msg_count LOOP
1782: -- get the actual message from fnd_msg_pub
1783: msg_details :=fnd_msg_pub.Get_Detail(p_msg_index=>i,p_encoded=>'F');

Line 1784: hr_utility.trace('msg_details:'||msg_details);

1780:
1781: FOR i IN 1 .. l_msg_count LOOP
1782: -- get the actual message from fnd_msg_pub
1783: msg_details :=fnd_msg_pub.Get_Detail(p_msg_index=>i,p_encoded=>'F');
1784: hr_utility.trace('msg_details:'||msg_details);
1785: if(instr(msg_details, '(FND_MESSAGE_TYPE=W)')) > 0 then
1786:
1787: lw_msg_count := lw_msg_count + 1;
1788: hr_utility.trace('Warning message:'||lw_msg_count);

Line 1788: hr_utility.trace('Warning message:'||lw_msg_count);

1784: hr_utility.trace('msg_details:'||msg_details);
1785: if(instr(msg_details, '(FND_MESSAGE_TYPE=W)')) > 0 then
1786:
1787: lw_msg_count := lw_msg_count + 1;
1788: hr_utility.trace('Warning message:'||lw_msg_count);
1789: end if;
1790:
1791: hr_utility.set_location('EO Error : ' || msg_details, 20);
1792: --

Line 1791: hr_utility.set_location('EO Error : ' || msg_details, 20);

1787: lw_msg_count := lw_msg_count + 1;
1788: hr_utility.trace('Warning message:'||lw_msg_count);
1789: end if;
1790:
1791: hr_utility.set_location('EO Error : ' || msg_details, 20);
1792: --
1793: END LOOP;
1794: if l_msg_count = lw_msg_count then
1795: l_return_status := 'S';

Line 1796: hr_utility.trace('l_return_status:'||l_return_status);

1792: --
1793: END LOOP;
1794: if l_msg_count = lw_msg_count then
1795: l_return_status := 'S';
1796: hr_utility.trace('l_return_status:'||l_return_status);
1797: end if;
1798: --Fix for Bug 14560350 end
1799:
1800:

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

1805: l_return_status);
1806: end if;
1807:
1808: p_return_status := l_return_status;
1809: hr_utility.set_location('Exiting:' || l_proc,40);
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: rollback to absence_process_api;
1813: hr_utility.trace('Exception in .process_api:' || SQLERRM );

Line 1813: hr_utility.trace('Exception in .process_api:' || SQLERRM );

1809: hr_utility.set_location('Exiting:' || l_proc,40);
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: rollback to absence_process_api;
1813: hr_utility.trace('Exception in .process_api:' || SQLERRM );
1814: hr_utility.set_location(' Leaving:' || l_proc,50);
1815:
1816: raise;
1817:

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

1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: rollback to absence_process_api;
1813: hr_utility.trace('Exception in .process_api:' || SQLERRM );
1814: hr_utility.set_location(' Leaving:' || l_proc,50);
1815:
1816: raise;
1817:
1818: END process_api;