DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_SWI dependencies on HR_UTILITY

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

95: and assignment_status_id > ias.assignment_status_id
96: );
97: --
98: Begin
99: hr_utility.set_location(' Entering:' || l_proc,10);
100: --
101: -- Initialise local variable
102: --
103: l_effective_date := trunc(p_effective_date);

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

164: ,p_change_reason => p_change_reason -- 4066579
165: ,p_status_change_comments => p_status_change_comments
166: );
167: End if;
168: hr_utility.set_location(' Leaving:' || l_proc,15);
169: Return TRUE;
170: END IF;
171: --
172: If l_new_per_system_status = L_ACTIVATE_APL_ASG then

Line 234: hr_utility.set_location(' Leaving:' || l_proc,18);

230: );
231: p_datetrack_update_mode := 'CORRECTION';
232: end if;
233: --
234: hr_utility.set_location(' Leaving:' || l_proc,18);
235: RETURN FALSE;
236: --
237: end if;
238: --

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

235: RETURN FALSE;
236: --
237: end if;
238: --
239: hr_utility.set_location(' Leaving:' || l_proc,20);
240: RETURN FALSE;
241: End chg_in_sys_status_to_term_apl;
242: --
243: -- ----------------------------------------------------------------------------

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

350: -- Other variables
351: l_assignment_id number;
352: l_proc varchar2(72) := g_package ||'create_secondary_apl_asg';
353: Begin
354: hr_utility.set_location(' Entering:' || l_proc,10);
355: --
356: -- Issue a savepoint
357: --
358: savepoint create_secondary_apl_asg_swi;

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

487: -- messages of any type exist in the Multiple Message List.
488: -- Also disable Multiple Message Detection.
489: --
490: p_return_status := hr_multi_message.get_return_status_disable;
491: hr_utility.set_location(' Leaving:' || l_proc,20);
492: --
493: exception
494: when hr_multi_message.error_message_exist then
495: --

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

512: p_effective_start_date := null;
513: p_effective_end_date := null;
514: p_assignment_sequence := null;
515: p_return_status := hr_multi_message.get_return_status_disable;
516: hr_utility.set_location(' Leaving:' || l_proc, 30);
517: when others then
518: --
519: -- When Multiple Message Detection is enabled catch
520: -- any Application specific or other unexpected

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

523: -- error.
524: --
525: rollback to create_secondary_apl_asg_swi;
526: if hr_multi_message.unexpected_error_add(l_proc) then
527: hr_utility.set_location(' Leaving:' || l_proc,40);
528: raise;
529: end if;
530: --
531: -- Reset IN OUT and set OUT parameters

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

541: p_effective_start_date := null;
542: p_effective_end_date := null;
543: p_assignment_sequence := null;
544: p_return_status := hr_multi_message.get_return_status_disable;
545: hr_utility.set_location(' Leaving:' || l_proc,50);
546: end create_secondary_apl_asg;
547: -- ----------------------------------------------------------------------------
548: -- |----------------------------< accept_apl_asg >----------------------------|
549: -- ----------------------------------------------------------------------------

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

568: --
569: -- Other variables
570: l_proc varchar2(72) := g_package ||'accept_apl_asg';
571: Begin
572: hr_utility.set_location(' Entering:' || l_proc,10);
573: --
574: -- Issue a savepoint
575: --
576: savepoint accept_apl_asg_swi;

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

617: -- messages of any type exist in the Multiple Message List.
618: -- Also disable Multiple Message Detection.
619: --
620: p_return_status := hr_multi_message.get_return_status_disable;
621: hr_utility.set_location(' Leaving:' || l_proc,20);
622: --
623: exception
624: when hr_multi_message.error_message_exist then
625: --

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

634: p_object_version_number := l_object_version_number;
635: p_effective_start_date := null;
636: p_effective_end_date := null;
637: p_return_status := hr_multi_message.get_return_status_disable;
638: hr_utility.set_location(' Leaving:' || l_proc, 30);
639: when others then
640: --
641: -- When Multiple Message Detection is enabled catch
642: -- any Application specific or other unexpected

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

645: -- error.
646: --
647: rollback to accept_apl_asg_swi;
648: if hr_multi_message.unexpected_error_add(l_proc) then
649: hr_utility.set_location(' Leaving:' || l_proc,40);
650: raise;
651: end if;
652: --
653: -- Reset IN OUT and set OUT parameters

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

655: p_object_version_number := l_object_version_number;
656: p_effective_start_date := null;
657: p_effective_end_date := null;
658: p_return_status := hr_multi_message.get_return_status_disable;
659: hr_utility.set_location(' Leaving:' || l_proc,50);
660: end accept_apl_asg;
661: -- ----------------------------------------------------------------------------
662: -- |---------------------------< activate_apl_asg >---------------------------|
663: -- ----------------------------------------------------------------------------

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

682: --
683: -- Other variables
684: l_proc varchar2(72) := g_package ||'activate_apl_asg';
685: Begin
686: hr_utility.set_location(' Entering:' || l_proc,10);
687: --
688: -- Issue a savepoint
689: --
690: savepoint activate_apl_asg_swi;

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

731: -- messages of any type exist in the Multiple Message List.
732: -- Also disable Multiple Message Detection.
733: --
734: p_return_status := hr_multi_message.get_return_status_disable;
735: hr_utility.set_location(' Leaving:' || l_proc,20);
736: --
737: exception
738: when hr_multi_message.error_message_exist then
739: --

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

748: p_object_version_number := l_object_version_number;
749: p_effective_start_date := null;
750: p_effective_end_date := null;
751: p_return_status := hr_multi_message.get_return_status_disable;
752: hr_utility.set_location(' Leaving:' || l_proc, 30);
753: when others then
754: --
755: -- When Multiple Message Detection is enabled catch
756: -- any Application specific or other unexpected

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

759: -- error.
760: --
761: rollback to activate_apl_asg_swi;
762: if hr_multi_message.unexpected_error_add(l_proc) then
763: hr_utility.set_location(' Leaving:' || l_proc,40);
764: raise;
765: end if;
766: --
767: -- Reset IN OUT and set OUT parameters

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

769: p_object_version_number := l_object_version_number;
770: p_effective_start_date := null;
771: p_effective_end_date := null;
772: p_return_status := hr_multi_message.get_return_status_disable;
773: hr_utility.set_location(' Leaving:' || l_proc,50);
774: end activate_apl_asg;
775: -- ----------------------------------------------------------------------------
776: -- |-----------------------------< offer_apl_asg >----------------------------|
777: -- ----------------------------------------------------------------------------

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

796: --
797: -- Other variables
798: l_proc varchar2(72) := g_package ||'offer_apl_asg';
799: Begin
800: hr_utility.set_location(' Entering:' || l_proc,10);
801: --
802: -- Issue a savepoint
803: --
804: savepoint offer_apl_asg_swi;

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

845: -- messages of any type exist in the Multiple Message List.
846: -- Also disable Multiple Message Detection.
847: --
848: p_return_status := hr_multi_message.get_return_status_disable;
849: hr_utility.set_location(' Leaving:' || l_proc,20);
850: --
851: exception
852: when hr_multi_message.error_message_exist then
853: --

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

862: p_object_version_number := l_object_version_number;
863: p_effective_start_date := null;
864: p_effective_end_date := null;
865: p_return_status := hr_multi_message.get_return_status_disable;
866: hr_utility.set_location(' Leaving:' || l_proc, 30);
867: when others then
868: --
869: -- When Multiple Message Detection is enabled catch
870: -- any Application specific or other unexpected

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

873: -- error.
874: --
875: rollback to offer_apl_asg_swi;
876: if hr_multi_message.unexpected_error_add(l_proc) then
877: hr_utility.set_location(' Leaving:' || l_proc,40);
878: raise;
879: end if;
880: --
881: -- Reset IN OUT and set OUT parameters

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

883: p_object_version_number := l_object_version_number;
884: p_effective_start_date := null;
885: p_effective_end_date := null;
886: p_return_status := hr_multi_message.get_return_status_disable;
887: hr_utility.set_location(' Leaving:' || l_proc,50);
888: end offer_apl_asg;
889: -- ----------------------------------------------------------------------------
890: -- |---------------------------< terminate_apl_asg >--------------------------|
891: -- ----------------------------------------------------------------------------

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

907: --
908: -- Other variables
909: l_proc varchar2(72) := g_package ||'terminate_apl_asg';
910: Begin
911: hr_utility.set_location(' Entering:' || l_proc,10);
912: --
913: -- Issue a savepoint
914: --
915: savepoint terminate_apl_asg_swi;

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

953: -- messages of any type exist in the Multiple Message List.
954: -- Also disable Multiple Message Detection.
955: --
956: p_return_status := hr_multi_message.get_return_status_disable;
957: hr_utility.set_location(' Leaving:' || l_proc,20);
958: --
959: exception
960: when hr_multi_message.error_message_exist then
961: --

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

970: p_object_version_number := l_object_version_number;
971: p_effective_start_date := null;
972: p_effective_end_date := null;
973: p_return_status := hr_multi_message.get_return_status_disable;
974: hr_utility.set_location(' Leaving:' || l_proc, 30);
975: when others then
976: --
977: -- When Multiple Message Detection is enabled catch
978: -- any Application specific or other unexpected

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

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

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

991: p_object_version_number := l_object_version_number;
992: p_effective_start_date := null;
993: p_effective_end_date := null;
994: p_return_status := hr_multi_message.get_return_status_disable;
995: hr_utility.set_location(' Leaving:' || l_proc,50);
996: end terminate_apl_asg;
997: -- ----------------------------------------------------------------------------
998: -- |----------------------------< update_apl_asg >----------------------------|
999: -- ----------------------------------------------------------------------------

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

1111: -- Other variables
1112: l_effective_date date;
1113: l_proc varchar2(72) := g_package ||'update_apl_asg';
1114: Begin
1115: hr_utility.set_location(' Entering:' || l_proc,10);
1116: --
1117: -- Initialise local variable
1118: --
1119: l_effective_date := trunc(p_effective_date);

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

1268: -- messages of any type exist in the Multiple Message List.
1269: -- Also disable Multiple Message Detection.
1270: --
1271: p_return_status := hr_multi_message.get_return_status_disable;
1272: hr_utility.set_location(' Leaving:' || l_proc,20);
1273: --
1274: exception
1275: when hr_multi_message.error_message_exist then
1276: --

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

1292: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1293: p_effective_start_date := null;
1294: p_effective_end_date := null;
1295: p_return_status := hr_multi_message.get_return_status_disable;
1296: hr_utility.set_location(' Leaving:' || l_proc, 30);
1297: when others then
1298: --
1299: -- When Multiple Message Detection is enabled catch
1300: -- any Application specific or other unexpected

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

1303: -- error.
1304: --
1305: rollback to update_apl_asg_swi;
1306: if hr_multi_message.unexpected_error_add(l_proc) then
1307: hr_utility.set_location(' Leaving:' || l_proc,40);
1308: raise;
1309: end if;
1310: --
1311: -- Reset IN OUT and set OUT parameters

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

1320: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1321: p_effective_start_date := null;
1322: p_effective_end_date := null;
1323: p_return_status := hr_multi_message.get_return_status_disable;
1324: hr_utility.set_location(' Leaving:' || l_proc,50);
1325: end update_apl_asg;
1326: --
1327: -- ----------------------------------------------------------------------------
1328: -- |----------------------------< update_emp_asg >----------------------------|

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

1470: --
1471: -- Other variables
1472: l_proc varchar2(72) := g_package ||'update_emp_asg';
1473: Begin
1474: hr_utility.set_location(' Entering:' || l_proc,10);
1475: --
1476: -- Issue a savepoint
1477: --
1478: savepoint update_emp_asg_swi;

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

1658: -- messages of any type exist in the Multiple Message List.
1659: -- Also disable Multiple Message Detection.
1660: --
1661: p_return_status := hr_multi_message.get_return_status_disable;
1662: hr_utility.set_location(' Leaving:' || l_proc,20);
1663: --
1664: exception
1665: when hr_multi_message.error_message_exist then
1666: --

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

1680: p_comment_id := null;
1681: p_effective_start_date := null;
1682: p_effective_end_date := null;
1683: p_return_status := hr_multi_message.get_return_status_disable;
1684: hr_utility.set_location(' Leaving:' || l_proc, 30);
1685: when others then
1686: --
1687: -- When Multiple Message Detection is enabled catch
1688: -- any Application specific or other unexpected

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

1691: -- error.
1692: --
1693: rollback to update_emp_asg_swi;
1694: if hr_multi_message.unexpected_error_add(l_proc) then
1695: hr_utility.set_location(' Leaving:' || l_proc,40);
1696: raise;
1697: end if;
1698: --
1699: -- Reset IN OUT and set OUT parameters

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

1706: p_comment_id := null;
1707: p_effective_start_date := null;
1708: p_effective_end_date := null;
1709: p_return_status := hr_multi_message.get_return_status_disable;
1710: hr_utility.set_location(' Leaving:' || l_proc,50);
1711: end update_emp_asg;
1712: --
1713: --
1714: --

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

1782: --
1783: -- Other variables
1784: l_proc varchar2(72) := g_package ||'update_emp_asg_criteria';
1785: Begin
1786: hr_utility.set_location(' Entering:' || l_proc,10);
1787: --
1788: -- Issue a savepoint
1789: --
1790: savepoint update_emp_asg_criteria_swi;

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

1900: -- messages of any type exist in the Multiple Message List.
1901: -- Also disable Multiple Message Detection.
1902: --
1903: p_return_status := hr_multi_message.get_return_status_disable;
1904: hr_utility.set_location(' Leaving:' || l_proc,20);
1905: --
1906: exception
1907: when hr_multi_message.error_message_exist then
1908: --

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

1920: p_effective_start_date := null;
1921: p_effective_end_date := null;
1922: p_people_group_id := null;
1923: p_return_status := hr_multi_message.get_return_status_disable;
1924: hr_utility.set_location(' Leaving:' || l_proc, 30);
1925: when others then
1926: --
1927: -- When Multiple Message Detection is enabled catch
1928: -- any Application specific or other unexpected

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

1931: -- error.
1932: --
1933: rollback to update_emp_asg_criteria_swi;
1934: if hr_multi_message.unexpected_error_add(l_proc) then
1935: hr_utility.set_location(' Leaving:' || l_proc,40);
1936: raise;
1937: end if;
1938: --
1939: -- Reset IN OUT and set OUT parameters

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

1944: p_effective_start_date := null;
1945: p_effective_end_date := null;
1946: p_people_group_id := null;
1947: p_return_status := hr_multi_message.get_return_status_disable;
1948: hr_utility.set_location(' Leaving:' || l_proc,50);
1949: end update_emp_asg_criteria;
1950:
1951: end hr_assignment_swi;