DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_SWI dependencies on HR_UTILITY

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

89: and assignment_status_id > ias.assignment_status_id
90: );
91: --
92: Begin
93: hr_utility.set_location(' Entering:' || l_proc,10);
94: --
95: -- Initialise local variable
96: --
97: l_effective_date := trunc(p_effective_date);

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

156: ,p_effective_end_date => p_effective_end_date
157: ,p_change_reason => p_change_reason -- 4066579
158: );
159: End if;
160: hr_utility.set_location(' Leaving:' || l_proc,15);
161: Return TRUE;
162: END IF;
163: --
164: If l_new_per_system_status = L_ACTIVATE_APL_ASG then

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

222: );
223: p_datetrack_update_mode := 'CORRECTION';
224: end if;
225: --
226: hr_utility.set_location(' Leaving:' || l_proc,18);
227: RETURN FALSE;
228: --
229: end if;
230: --

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

227: RETURN FALSE;
228: --
229: end if;
230: --
231: hr_utility.set_location(' Leaving:' || l_proc,20);
232: RETURN FALSE;
233: End chg_in_sys_status_to_term_apl;
234: --
235: -- ----------------------------------------------------------------------------

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

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

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

479: -- messages of any type exist in the Multiple Message List.
480: -- Also disable Multiple Message Detection.
481: --
482: p_return_status := hr_multi_message.get_return_status_disable;
483: hr_utility.set_location(' Leaving:' || l_proc,20);
484: --
485: exception
486: when hr_multi_message.error_message_exist then
487: --

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

504: p_effective_start_date := null;
505: p_effective_end_date := null;
506: p_assignment_sequence := null;
507: p_return_status := hr_multi_message.get_return_status_disable;
508: hr_utility.set_location(' Leaving:' || l_proc, 30);
509: when others then
510: --
511: -- When Multiple Message Detection is enabled catch
512: -- any Application specific or other unexpected

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

515: -- error.
516: --
517: rollback to create_secondary_apl_asg_swi;
518: if hr_multi_message.unexpected_error_add(l_proc) then
519: hr_utility.set_location(' Leaving:' || l_proc,40);
520: raise;
521: end if;
522: --
523: -- Reset IN OUT and set OUT parameters

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

533: p_effective_start_date := null;
534: p_effective_end_date := null;
535: p_assignment_sequence := null;
536: p_return_status := hr_multi_message.get_return_status_disable;
537: hr_utility.set_location(' Leaving:' || l_proc,50);
538: end create_secondary_apl_asg;
539: -- ----------------------------------------------------------------------------
540: -- |----------------------------< accept_apl_asg >----------------------------|
541: -- ----------------------------------------------------------------------------

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

560: --
561: -- Other variables
562: l_proc varchar2(72) := g_package ||'accept_apl_asg';
563: Begin
564: hr_utility.set_location(' Entering:' || l_proc,10);
565: --
566: -- Issue a savepoint
567: --
568: savepoint accept_apl_asg_swi;

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

609: -- messages of any type exist in the Multiple Message List.
610: -- Also disable Multiple Message Detection.
611: --
612: p_return_status := hr_multi_message.get_return_status_disable;
613: hr_utility.set_location(' Leaving:' || l_proc,20);
614: --
615: exception
616: when hr_multi_message.error_message_exist then
617: --

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

626: p_object_version_number := l_object_version_number;
627: p_effective_start_date := null;
628: p_effective_end_date := null;
629: p_return_status := hr_multi_message.get_return_status_disable;
630: hr_utility.set_location(' Leaving:' || l_proc, 30);
631: when others then
632: --
633: -- When Multiple Message Detection is enabled catch
634: -- any Application specific or other unexpected

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

637: -- error.
638: --
639: rollback to accept_apl_asg_swi;
640: if hr_multi_message.unexpected_error_add(l_proc) then
641: hr_utility.set_location(' Leaving:' || l_proc,40);
642: raise;
643: end if;
644: --
645: -- Reset IN OUT and set OUT parameters

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

647: p_object_version_number := l_object_version_number;
648: p_effective_start_date := null;
649: p_effective_end_date := null;
650: p_return_status := hr_multi_message.get_return_status_disable;
651: hr_utility.set_location(' Leaving:' || l_proc,50);
652: end accept_apl_asg;
653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< activate_apl_asg >---------------------------|
655: -- ----------------------------------------------------------------------------

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

674: --
675: -- Other variables
676: l_proc varchar2(72) := g_package ||'activate_apl_asg';
677: Begin
678: hr_utility.set_location(' Entering:' || l_proc,10);
679: --
680: -- Issue a savepoint
681: --
682: savepoint activate_apl_asg_swi;

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

723: -- messages of any type exist in the Multiple Message List.
724: -- Also disable Multiple Message Detection.
725: --
726: p_return_status := hr_multi_message.get_return_status_disable;
727: hr_utility.set_location(' Leaving:' || l_proc,20);
728: --
729: exception
730: when hr_multi_message.error_message_exist then
731: --

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

740: p_object_version_number := l_object_version_number;
741: p_effective_start_date := null;
742: p_effective_end_date := null;
743: p_return_status := hr_multi_message.get_return_status_disable;
744: hr_utility.set_location(' Leaving:' || l_proc, 30);
745: when others then
746: --
747: -- When Multiple Message Detection is enabled catch
748: -- any Application specific or other unexpected

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

751: -- error.
752: --
753: rollback to activate_apl_asg_swi;
754: if hr_multi_message.unexpected_error_add(l_proc) then
755: hr_utility.set_location(' Leaving:' || l_proc,40);
756: raise;
757: end if;
758: --
759: -- Reset IN OUT and set OUT parameters

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

761: p_object_version_number := l_object_version_number;
762: p_effective_start_date := null;
763: p_effective_end_date := null;
764: p_return_status := hr_multi_message.get_return_status_disable;
765: hr_utility.set_location(' Leaving:' || l_proc,50);
766: end activate_apl_asg;
767: -- ----------------------------------------------------------------------------
768: -- |-----------------------------< offer_apl_asg >----------------------------|
769: -- ----------------------------------------------------------------------------

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

788: --
789: -- Other variables
790: l_proc varchar2(72) := g_package ||'offer_apl_asg';
791: Begin
792: hr_utility.set_location(' Entering:' || l_proc,10);
793: --
794: -- Issue a savepoint
795: --
796: savepoint offer_apl_asg_swi;

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

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

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

854: p_object_version_number := l_object_version_number;
855: p_effective_start_date := null;
856: p_effective_end_date := null;
857: p_return_status := hr_multi_message.get_return_status_disable;
858: hr_utility.set_location(' Leaving:' || l_proc, 30);
859: when others then
860: --
861: -- When Multiple Message Detection is enabled catch
862: -- any Application specific or other unexpected

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

865: -- error.
866: --
867: rollback to offer_apl_asg_swi;
868: if hr_multi_message.unexpected_error_add(l_proc) then
869: hr_utility.set_location(' Leaving:' || l_proc,40);
870: raise;
871: end if;
872: --
873: -- Reset IN OUT and set OUT parameters

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

875: p_object_version_number := l_object_version_number;
876: p_effective_start_date := null;
877: p_effective_end_date := null;
878: p_return_status := hr_multi_message.get_return_status_disable;
879: hr_utility.set_location(' Leaving:' || l_proc,50);
880: end offer_apl_asg;
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< terminate_apl_asg >--------------------------|
883: -- ----------------------------------------------------------------------------

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

899: --
900: -- Other variables
901: l_proc varchar2(72) := g_package ||'terminate_apl_asg';
902: Begin
903: hr_utility.set_location(' Entering:' || l_proc,10);
904: --
905: -- Issue a savepoint
906: --
907: savepoint terminate_apl_asg_swi;

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

945: -- messages of any type exist in the Multiple Message List.
946: -- Also disable Multiple Message Detection.
947: --
948: p_return_status := hr_multi_message.get_return_status_disable;
949: hr_utility.set_location(' Leaving:' || l_proc,20);
950: --
951: exception
952: when hr_multi_message.error_message_exist then
953: --

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

962: p_object_version_number := l_object_version_number;
963: p_effective_start_date := null;
964: p_effective_end_date := null;
965: p_return_status := hr_multi_message.get_return_status_disable;
966: hr_utility.set_location(' Leaving:' || l_proc, 30);
967: when others then
968: --
969: -- When Multiple Message Detection is enabled catch
970: -- any Application specific or other unexpected

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

973: -- error.
974: --
975: rollback to terminate_apl_asg_swi;
976: if hr_multi_message.unexpected_error_add(l_proc) then
977: hr_utility.set_location(' Leaving:' || l_proc,40);
978: raise;
979: end if;
980: --
981: -- Reset IN OUT and set OUT parameters

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

983: p_object_version_number := l_object_version_number;
984: p_effective_start_date := null;
985: p_effective_end_date := null;
986: p_return_status := hr_multi_message.get_return_status_disable;
987: hr_utility.set_location(' Leaving:' || l_proc,50);
988: end terminate_apl_asg;
989: -- ----------------------------------------------------------------------------
990: -- |----------------------------< update_apl_asg >----------------------------|
991: -- ----------------------------------------------------------------------------

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

1102: -- Other variables
1103: l_effective_date date;
1104: l_proc varchar2(72) := g_package ||'update_apl_asg';
1105: Begin
1106: hr_utility.set_location(' Entering:' || l_proc,10);
1107: --
1108: -- Initialise local variable
1109: --
1110: l_effective_date := trunc(p_effective_date);

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

1258: -- messages of any type exist in the Multiple Message List.
1259: -- Also disable Multiple Message Detection.
1260: --
1261: p_return_status := hr_multi_message.get_return_status_disable;
1262: hr_utility.set_location(' Leaving:' || l_proc,20);
1263: --
1264: exception
1265: when hr_multi_message.error_message_exist then
1266: --

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

1282: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1283: p_effective_start_date := null;
1284: p_effective_end_date := null;
1285: p_return_status := hr_multi_message.get_return_status_disable;
1286: hr_utility.set_location(' Leaving:' || l_proc, 30);
1287: when others then
1288: --
1289: -- When Multiple Message Detection is enabled catch
1290: -- any Application specific or other unexpected

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

1293: -- error.
1294: --
1295: rollback to update_apl_asg_swi;
1296: if hr_multi_message.unexpected_error_add(l_proc) then
1297: hr_utility.set_location(' Leaving:' || l_proc,40);
1298: raise;
1299: end if;
1300: --
1301: -- Reset IN OUT and set OUT parameters

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

1310: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1311: p_effective_start_date := null;
1312: p_effective_end_date := null;
1313: p_return_status := hr_multi_message.get_return_status_disable;
1314: hr_utility.set_location(' Leaving:' || l_proc,50);
1315: end update_apl_asg;
1316: --
1317: -- ----------------------------------------------------------------------------
1318: -- |----------------------------< update_emp_asg >----------------------------|

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

1460: --
1461: -- Other variables
1462: l_proc varchar2(72) := g_package ||'update_emp_asg';
1463: Begin
1464: hr_utility.set_location(' Entering:' || l_proc,10);
1465: --
1466: -- Issue a savepoint
1467: --
1468: savepoint update_emp_asg_swi;

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

1648: -- messages of any type exist in the Multiple Message List.
1649: -- Also disable Multiple Message Detection.
1650: --
1651: p_return_status := hr_multi_message.get_return_status_disable;
1652: hr_utility.set_location(' Leaving:' || l_proc,20);
1653: --
1654: exception
1655: when hr_multi_message.error_message_exist then
1656: --

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

1670: p_comment_id := null;
1671: p_effective_start_date := null;
1672: p_effective_end_date := null;
1673: p_return_status := hr_multi_message.get_return_status_disable;
1674: hr_utility.set_location(' Leaving:' || l_proc, 30);
1675: when others then
1676: --
1677: -- When Multiple Message Detection is enabled catch
1678: -- any Application specific or other unexpected

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

1681: -- error.
1682: --
1683: rollback to update_emp_asg_swi;
1684: if hr_multi_message.unexpected_error_add(l_proc) then
1685: hr_utility.set_location(' Leaving:' || l_proc,40);
1686: raise;
1687: end if;
1688: --
1689: -- Reset IN OUT and set OUT parameters

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

1696: p_comment_id := null;
1697: p_effective_start_date := null;
1698: p_effective_end_date := null;
1699: p_return_status := hr_multi_message.get_return_status_disable;
1700: hr_utility.set_location(' Leaving:' || l_proc,50);
1701: end update_emp_asg;
1702: --
1703: --
1704: --

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

1772: --
1773: -- Other variables
1774: l_proc varchar2(72) := g_package ||'update_emp_asg_criteria';
1775: Begin
1776: hr_utility.set_location(' Entering:' || l_proc,10);
1777: --
1778: -- Issue a savepoint
1779: --
1780: savepoint update_emp_asg_criteria_swi;

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

1890: -- messages of any type exist in the Multiple Message List.
1891: -- Also disable Multiple Message Detection.
1892: --
1893: p_return_status := hr_multi_message.get_return_status_disable;
1894: hr_utility.set_location(' Leaving:' || l_proc,20);
1895: --
1896: exception
1897: when hr_multi_message.error_message_exist then
1898: --

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

1910: p_effective_start_date := null;
1911: p_effective_end_date := null;
1912: p_people_group_id := null;
1913: p_return_status := hr_multi_message.get_return_status_disable;
1914: hr_utility.set_location(' Leaving:' || l_proc, 30);
1915: when others then
1916: --
1917: -- When Multiple Message Detection is enabled catch
1918: -- any Application specific or other unexpected

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

1921: -- error.
1922: --
1923: rollback to update_emp_asg_criteria_swi;
1924: if hr_multi_message.unexpected_error_add(l_proc) then
1925: hr_utility.set_location(' Leaving:' || l_proc,40);
1926: raise;
1927: end if;
1928: --
1929: -- Reset IN OUT and set OUT parameters

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

1934: p_effective_start_date := null;
1935: p_effective_end_date := null;
1936: p_people_group_id := null;
1937: p_return_status := hr_multi_message.get_return_status_disable;
1938: hr_utility.set_location(' Leaving:' || l_proc,50);
1939: end update_emp_asg_criteria;
1940:
1941: end hr_assignment_swi;