DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_ISETUP_SWI dependencies on HR_UTILITY

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

115: -- Other variables
116: l_assignment_id number;
117: l_proc varchar2(72) := g_package ||'create_secondary_apl_asg';
118: Begin
119: hr_utility.set_location(' Entering:' || l_proc,10);
120: --
121: -- Issue a savepoint
122: --
123: savepoint create_secondary_apl_asg_swi;

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

252: -- messages of any type exist in the Multiple Message List.
253: -- Also disable Multiple Message Detection.
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,20);
257: --
258: exception
259: when hr_multi_message.error_message_exist then
260: --

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

277: p_effective_start_date := null;
278: p_effective_end_date := null;
279: p_assignment_sequence := null;
280: p_return_status := hr_multi_message.get_return_status_disable;
281: hr_utility.set_location(' Leaving:' || l_proc, 30);
282: when others then
283: --
284: -- When Multiple Message Detection is enabled catch
285: -- any Application specific or other unexpected

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

288: -- error.
289: --
290: rollback to create_secondary_apl_asg_swi;
291: if hr_multi_message.unexpected_error_add(l_proc) then
292: hr_utility.set_location(' Leaving:' || l_proc,40);
293: raise;
294: end if;
295: --
296: -- Reset IN OUT and set OUT parameters

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

306: p_effective_start_date := null;
307: p_effective_end_date := null;
308: p_assignment_sequence := null;
309: p_return_status := hr_multi_message.get_return_status_disable;
310: hr_utility.set_location(' Leaving:' || l_proc,50);
311: end create_secondary_apl_asg;
312: -- ----------------------------------------------------------------------------
313: -- |----------------------------< accept_apl_asg >----------------------------|
314: -- ----------------------------------------------------------------------------

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

333: --
334: -- Other variables
335: l_proc varchar2(72) := g_package ||'accept_apl_asg';
336: Begin
337: hr_utility.set_location(' Entering:' || l_proc,10);
338: --
339: -- Issue a savepoint
340: --
341: savepoint accept_apl_asg_swi;

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

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

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

399: p_object_version_number := l_object_version_number;
400: p_effective_start_date := null;
401: p_effective_end_date := null;
402: p_return_status := hr_multi_message.get_return_status_disable;
403: hr_utility.set_location(' Leaving:' || l_proc, 30);
404: when others then
405: --
406: -- When Multiple Message Detection is enabled catch
407: -- any Application specific or other unexpected

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

410: -- error.
411: --
412: rollback to accept_apl_asg_swi;
413: if hr_multi_message.unexpected_error_add(l_proc) then
414: hr_utility.set_location(' Leaving:' || l_proc,40);
415: raise;
416: end if;
417: --
418: -- Reset IN OUT and set OUT parameters

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

420: p_object_version_number := l_object_version_number;
421: p_effective_start_date := null;
422: p_effective_end_date := null;
423: p_return_status := hr_multi_message.get_return_status_disable;
424: hr_utility.set_location(' Leaving:' || l_proc,50);
425: end accept_apl_asg;
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------< activate_apl_asg >---------------------------|
428: -- ----------------------------------------------------------------------------

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

447: --
448: -- Other variables
449: l_proc varchar2(72) := g_package ||'activate_apl_asg';
450: Begin
451: hr_utility.set_location(' Entering:' || l_proc,10);
452: --
453: -- Issue a savepoint
454: --
455: savepoint activate_apl_asg_swi;

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

496: -- messages of any type exist in the Multiple Message List.
497: -- Also disable Multiple Message Detection.
498: --
499: p_return_status := hr_multi_message.get_return_status_disable;
500: hr_utility.set_location(' Leaving:' || l_proc,20);
501: --
502: exception
503: when hr_multi_message.error_message_exist then
504: --

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

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

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

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

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

534: p_object_version_number := l_object_version_number;
535: p_effective_start_date := null;
536: p_effective_end_date := null;
537: p_return_status := hr_multi_message.get_return_status_disable;
538: hr_utility.set_location(' Leaving:' || l_proc,50);
539: end activate_apl_asg;
540: -- ----------------------------------------------------------------------------
541: -- |-----------------------------< offer_apl_asg >----------------------------|
542: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

672: --
673: -- Other variables
674: l_proc varchar2(72) := g_package ||'terminate_apl_asg';
675: Begin
676: hr_utility.set_location(' Entering:' || l_proc,10);
677: --
678: -- Issue a savepoint
679: --
680: savepoint terminate_apl_asg_swi;

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

718: -- messages of any type exist in the Multiple Message List.
719: -- Also disable Multiple Message Detection.
720: --
721: p_return_status := hr_multi_message.get_return_status_disable;
722: hr_utility.set_location(' Leaving:' || l_proc,20);
723: --
724: exception
725: when hr_multi_message.error_message_exist then
726: --

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

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

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

746: -- error.
747: --
748: rollback to terminate_apl_asg_swi;
749: if hr_multi_message.unexpected_error_add(l_proc) then
750: hr_utility.set_location(' Leaving:' || l_proc,40);
751: raise;
752: end if;
753: --
754: -- Reset IN OUT and set OUT parameters

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

756: p_object_version_number := l_object_version_number;
757: p_effective_start_date := null;
758: p_effective_end_date := null;
759: p_return_status := hr_multi_message.get_return_status_disable;
760: hr_utility.set_location(' Leaving:' || l_proc,50);
761: end terminate_apl_asg;
762: -- ----------------------------------------------------------------------------
763: -- |----------------------------< update_apl_asg >----------------------------|
764: -- ----------------------------------------------------------------------------

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

869: --
870: -- Other variables
871: l_proc varchar2(72) := g_package ||'update_apl_asg';
872: Begin
873: hr_utility.set_location(' Entering:' || l_proc,10);
874: --
875: -- Issue a savepoint
876: --
877: savepoint update_apl_asg_swi;

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

1004: -- messages of any type exist in the Multiple Message List.
1005: -- Also disable Multiple Message Detection.
1006: --
1007: p_return_status := hr_multi_message.get_return_status_disable;
1008: hr_utility.set_location(' Leaving:' || l_proc,20);
1009: --
1010: exception
1011: when hr_multi_message.error_message_exist then
1012: --

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

1028: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1029: p_effective_start_date := null;
1030: p_effective_end_date := null;
1031: p_return_status := hr_multi_message.get_return_status_disable;
1032: hr_utility.set_location(' Leaving:' || l_proc, 30);
1033: when others then
1034: --
1035: -- When Multiple Message Detection is enabled catch
1036: -- any Application specific or other unexpected

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

1039: -- error.
1040: --
1041: rollback to update_apl_asg_swi;
1042: if hr_multi_message.unexpected_error_add(l_proc) then
1043: hr_utility.set_location(' Leaving:' || l_proc,40);
1044: raise;
1045: end if;
1046: --
1047: -- Reset IN OUT and set OUT parameters

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

1056: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1057: p_effective_start_date := null;
1058: p_effective_end_date := null;
1059: p_return_status := hr_multi_message.get_return_status_disable;
1060: hr_utility.set_location(' Leaving:' || l_proc,50);
1061: end update_apl_asg;
1062: --
1063: -- ----------------------------------------------------------------------------
1064: -- |----------------------------< update_emp_asg >----------------------------|

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

1211: -- Other variables
1212: l_proc varchar2(72) := g_package ||'update_emp_asg';
1213: l_scl_keyflex_id number(15);
1214: Begin
1215: hr_utility.set_location(' Entering:' || l_proc,10);
1216: --
1217: -- Issue a savepoint
1218: --
1219: savepoint update_emp_asg_swi;

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

1416: -- messages of any type exist in the Multiple Message List.
1417: -- Also disable Multiple Message Detection.
1418: --
1419: p_return_status := hr_multi_message.get_return_status_disable;
1420: hr_utility.set_location(' Leaving:' || l_proc,20);
1421: --
1422: exception
1423: when hr_multi_message.error_message_exist then
1424: --

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

1438: p_comment_id := null;
1439: p_effective_start_date := null;
1440: p_effective_end_date := null;
1441: p_return_status := hr_multi_message.get_return_status_disable;
1442: hr_utility.set_location(' Leaving:' || l_proc, 30);
1443: when others then
1444: --
1445: -- When Multiple Message Detection is enabled catch
1446: -- any Application specific or other unexpected

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

1449: -- error.
1450: --
1451: rollback to update_emp_asg_swi;
1452: if hr_multi_message.unexpected_error_add(l_proc) then
1453: hr_utility.set_location(' Leaving:' || l_proc,40);
1454: raise;
1455: end if;
1456: --
1457: -- Reset IN OUT and set OUT parameters

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

1464: p_comment_id := null;
1465: p_effective_start_date := null;
1466: p_effective_end_date := null;
1467: p_return_status := hr_multi_message.get_return_status_disable;
1468: hr_utility.set_location(' Leaving:' || l_proc,50);
1469: end update_emp_asg;
1470: --
1471: --
1472: --

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

1540: --
1541: -- Other variables
1542: l_proc varchar2(72) := g_package ||'update_emp_asg_criteria';
1543: Begin
1544: hr_utility.set_location(' Entering:' || l_proc,10);
1545: --
1546: -- Issue a savepoint
1547: --
1548: savepoint update_emp_asg_criteria_swi;

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

1665: -- messages of any type exist in the Multiple Message List.
1666: -- Also disable Multiple Message Detection.
1667: --
1668: p_return_status := hr_multi_message.get_return_status_disable;
1669: hr_utility.set_location(' Leaving:' || l_proc,20);
1670: --
1671: exception
1672: when hr_multi_message.error_message_exist then
1673: --

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

1685: p_effective_start_date := null;
1686: p_effective_end_date := null;
1687: p_people_group_id := null;
1688: p_return_status := hr_multi_message.get_return_status_disable;
1689: hr_utility.set_location(' Leaving:' || l_proc, 30);
1690: when others then
1691: --
1692: -- When Multiple Message Detection is enabled catch
1693: -- any Application specific or other unexpected

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

1696: -- error.
1697: --
1698: rollback to update_emp_asg_criteria_swi;
1699: if hr_multi_message.unexpected_error_add(l_proc) then
1700: hr_utility.set_location(' Leaving:' || l_proc,40);
1701: raise;
1702: end if;
1703: --
1704: -- Reset IN OUT and set OUT parameters

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

1709: p_effective_start_date := null;
1710: p_effective_end_date := null;
1711: p_people_group_id := null;
1712: p_return_status := hr_multi_message.get_return_status_disable;
1713: hr_utility.set_location(' Leaving:' || l_proc,50);
1714: end update_emp_asg_criteria;
1715: --
1716: --
1717: -- ----------------------------------------------------------------------------