DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_SWI dependencies on HR_UTILITY

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

110: and trunc(p_effective_date)
111: between per.effective_start_date
112: and per.effective_end_date;
113: Begin
114: hr_utility.set_location(' Entering:' || l_proc,10);
115: --
116: -- Issue a savepoint
117: --
118: savepoint create_previous_employer_swi;

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

242: -- messages of any type exist in the Multiple Message List.
243: -- Also disable Multiple Message Detection.
244: --
245: p_return_status := hr_multi_message.get_return_status_disable;
246: hr_utility.set_location(' Leaving:' || l_proc,20);
247: --
248: exception
249: when hr_multi_message.error_message_exist then
250: --

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

257: -- Reset IN OUT parameters and set OUT parameters
258: --
259: p_object_version_number := null;
260: p_return_status := hr_multi_message.get_return_status_disable;
261: hr_utility.set_location(' Leaving:' || l_proc, 30);
262: when others then
263: --
264: -- When Multiple Message Detection is enabled catch
265: -- any Application specific or other unexpected

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

268: -- error.
269: --
270: rollback to create_previous_employer_swi;
271: if hr_multi_message.unexpected_error_add(l_proc) then
272: hr_utility.set_location(' Leaving:' || l_proc,40);
273: raise;
274: end if;
275: --
276: -- Reset IN OUT and set OUT parameters

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

276: -- Reset IN OUT and set OUT parameters
277: --
278: p_object_version_number := null;
279: p_return_status := hr_multi_message.get_return_status_disable;
280: hr_utility.set_location(' Leaving:' || l_proc,50);
281: end create_previous_employer;
282: -- ----------------------------------------------------------------------------
283: -- |-----------------------< delete_previous_employer >-----------------------|
284: -- ----------------------------------------------------------------------------

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

297: --
298: -- Other variables
299: l_proc varchar2(72) := g_package ||'delete_previous_employer';
300: Begin
301: hr_utility.set_location(' Entering:' || l_proc,10);
302: --
303: -- Issue a savepoint
304: --
305: savepoint delete_previous_employer_swi;

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

340: -- messages of any type exist in the Multiple Message List.
341: -- Also disable Multiple Message Detection.
342: --
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc,20);
345: --
346: exception
347: when hr_multi_message.error_message_exist then
348: --

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

355: -- Reset IN OUT parameters and set OUT parameters
356: --
357: p_object_version_number := l_object_version_number;
358: p_return_status := hr_multi_message.get_return_status_disable;
359: hr_utility.set_location(' Leaving:' || l_proc, 30);
360: when others then
361: --
362: -- When Multiple Message Detection is enabled catch
363: -- any Application specific or other unexpected

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

366: -- error.
367: --
368: rollback to delete_previous_employer_swi;
369: if hr_multi_message.unexpected_error_add(l_proc) then
370: hr_utility.set_location(' Leaving:' || l_proc,40);
371: raise;
372: end if;
373: --
374: -- Reset IN OUT and set OUT parameters

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

374: -- Reset IN OUT and set OUT parameters
375: --
376: p_object_version_number := l_object_version_number;
377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,50);
379: end delete_previous_employer;
380: -- ----------------------------------------------------------------------------
381: -- |-----------------------< update_previous_employer >-----------------------|
382: -- ----------------------------------------------------------------------------

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

470: --
471: -- Other variables
472: l_proc varchar2(72) := g_package ||'update_previous_employer';
473: Begin
474: hr_utility.set_location(' Entering:' || l_proc,10);
475: --
476: -- Issue a savepoint
477: --
478: savepoint update_previous_employer_swi;

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

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

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

603: -- Reset IN OUT parameters and set OUT parameters
604: --
605: p_object_version_number := l_object_version_number;
606: p_return_status := hr_multi_message.get_return_status_disable;
607: hr_utility.set_location(' Leaving:' || l_proc, 30);
608: when others then
609: --
610: -- When Multiple Message Detection is enabled catch
611: -- any Application specific or other unexpected

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

614: -- error.
615: --
616: rollback to update_previous_employer_swi;
617: if hr_multi_message.unexpected_error_add(l_proc) then
618: hr_utility.set_location(' Leaving:' || l_proc,40);
619: raise;
620: end if;
621: --
622: -- Reset IN OUT and set OUT parameters

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

622: -- Reset IN OUT and set OUT parameters
623: --
624: p_object_version_number := l_object_version_number;
625: p_return_status := hr_multi_message.get_return_status_disable;
626: hr_utility.set_location(' Leaving:' || l_proc,50);
627: end update_previous_employer;
628: -- ----------------------------------------------------------------------------
629: -- |--------------------------< create_previous_job >-------------------------|
630: -- ----------------------------------------------------------------------------

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

716: -- Other variables
717: l_previous_job_id number;
718: l_proc varchar2(72) := g_package ||'create_previous_job';
719: Begin
720: hr_utility.set_location(' Entering:' || l_proc,10);
721: --
722: -- Issue a savepoint
723: --
724: savepoint create_previous_job_swi;

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

834: -- messages of any type exist in the Multiple Message List.
835: -- Also disable Multiple Message Detection.
836: --
837: p_return_status := hr_multi_message.get_return_status_disable;
838: hr_utility.set_location(' Leaving:' || l_proc,20);
839: --
840: exception
841: when hr_multi_message.error_message_exist then
842: --

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

849: -- Reset IN OUT parameters and set OUT parameters
850: --
851: p_object_version_number := null;
852: p_return_status := hr_multi_message.get_return_status_disable;
853: hr_utility.set_location(' Leaving:' || l_proc, 30);
854: when others then
855: --
856: -- When Multiple Message Detection is enabled catch
857: -- any Application specific or other unexpected

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

860: -- error.
861: --
862: rollback to create_previous_job_swi;
863: if hr_multi_message.unexpected_error_add(l_proc) then
864: hr_utility.set_location(' Leaving:' || l_proc,40);
865: raise;
866: end if;
867: --
868: -- Reset IN OUT and set OUT parameters

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

868: -- Reset IN OUT and set OUT parameters
869: --
870: p_object_version_number := null;
871: p_return_status := hr_multi_message.get_return_status_disable;
872: hr_utility.set_location(' Leaving:' || l_proc,50);
873: end create_previous_job;
874: -- ----------------------------------------------------------------------------
875: -- |--------------------------< delete_previous_job >-------------------------|
876: -- ----------------------------------------------------------------------------

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

889: --
890: -- Other variables
891: l_proc varchar2(72) := g_package ||'delete_previous_job';
892: Begin
893: hr_utility.set_location(' Entering:' || l_proc,10);
894: --
895: -- Issue a savepoint
896: --
897: savepoint delete_previous_job_swi;

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

932: -- messages of any type exist in the Multiple Message List.
933: -- Also disable Multiple Message Detection.
934: --
935: p_return_status := hr_multi_message.get_return_status_disable;
936: hr_utility.set_location(' Leaving:' || l_proc,20);
937: --
938: exception
939: when hr_multi_message.error_message_exist then
940: --

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

947: -- Reset IN OUT parameters and set OUT parameters
948: --
949: p_object_version_number := l_object_version_number;
950: p_return_status := hr_multi_message.get_return_status_disable;
951: hr_utility.set_location(' Leaving:' || l_proc, 30);
952: when others then
953: --
954: -- When Multiple Message Detection is enabled catch
955: -- any Application specific or other unexpected

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

958: -- error.
959: --
960: rollback to delete_previous_job_swi;
961: if hr_multi_message.unexpected_error_add(l_proc) then
962: hr_utility.set_location(' Leaving:' || l_proc,40);
963: raise;
964: end if;
965: --
966: -- Reset IN OUT and set OUT parameters

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

966: -- Reset IN OUT and set OUT parameters
967: --
968: p_object_version_number := l_object_version_number;
969: p_return_status := hr_multi_message.get_return_status_disable;
970: hr_utility.set_location(' Leaving:' || l_proc,50);
971: end delete_previous_job;
972: -- ----------------------------------------------------------------------------
973: -- |--------------------------< update_previous_job >-------------------------|
974: -- ----------------------------------------------------------------------------

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

1059: --
1060: -- Other variables
1061: l_proc varchar2(72) := g_package ||'update_previous_job';
1062: Begin
1063: hr_utility.set_location(' Entering:' || l_proc,10);
1064: --
1065: -- Issue a savepoint
1066: --
1067: savepoint update_previous_job_swi;

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

1174: -- messages of any type exist in the Multiple Message List.
1175: -- Also disable Multiple Message Detection.
1176: --
1177: p_return_status := hr_multi_message.get_return_status_disable;
1178: hr_utility.set_location(' Leaving:' || l_proc,20);
1179: --
1180: exception
1181: when hr_multi_message.error_message_exist then
1182: --

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

1189: -- Reset IN OUT parameters and set OUT parameters
1190: --
1191: p_object_version_number := l_object_version_number;
1192: p_return_status := hr_multi_message.get_return_status_disable;
1193: hr_utility.set_location(' Leaving:' || l_proc, 30);
1194: when others then
1195: --
1196: -- When Multiple Message Detection is enabled catch
1197: -- any Application specific or other unexpected

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

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

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

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