DBA Data[Home] [Help]

APPS.IRC_OFFERS_SWI dependencies on HR_MULTI_MESSAGE

Line 83: hr_multi_message.enable_message_list;

79: savepoint create_offer_swi;
80: --
81: -- Initialise Multiple Message Detection
82: --
83: hr_multi_message.enable_message_list;
84: --
85: -- Remember IN OUT parameter IN values
86: --
87: --

Line 171: p_return_status := hr_multi_message.get_return_status_disable;

167: -- messages of any type exist in the Multiple Message List.
168: -- Also disable Multiple Message Detection.
169: --
170: --
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,20);
173: --
174: exception
175: when hr_multi_message.error_message_exist then

Line 175: when hr_multi_message.error_message_exist then

171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,20);
173: --
174: exception
175: when hr_multi_message.error_message_exist then
176: --
177: -- Catch the Multiple Message List exception which
178: -- indicates API processing has been aborted because
179: -- at least one message exists in the list.

Line 187: p_return_status := hr_multi_message.get_return_status_disable;

183: -- Reset IN OUT parameters and set OUT parameters
184: --
185: p_offer_version := null;
186: p_object_version_number := null;
187: p_return_status := hr_multi_message.get_return_status_disable;
188: hr_utility.set_location(' Leaving:' || l_proc, 30);
189: when others then
190: --
191: -- When Multiple Message Detection is enabled catch

Line 198: if hr_multi_message.unexpected_error_add(l_proc) then

194: -- Multiple Message List. Otherwise re-raise the
195: -- error.
196: --
197: rollback to create_offer_swi;
198: if hr_multi_message.unexpected_error_add(l_proc) then
199: hr_utility.set_location(' Leaving:' || l_proc,40);
200: raise;
201: end if;
202: --

Line 207: p_return_status := hr_multi_message.get_return_status_disable;

203: -- Reset IN OUT and set OUT parameters
204: --
205: p_offer_version := null;
206: p_object_version_number := null;
207: p_return_status := hr_multi_message.get_return_status_disable;
208: hr_utility.set_location(' Leaving:' || l_proc,50);
209: end create_offer;
210: -- ----------------------------------------------------------------------------
211: -- |-----------------------------< update_offer >-----------------------------|

Line 290: hr_multi_message.enable_message_list;

286: savepoint update_offer_swi;
287: --
288: -- Initialise Multiple Message Detection
289: --
290: hr_multi_message.enable_message_list;
291: --
292: -- Remember IN OUT parameter IN values
293: --
294: l_offer_id := p_offer_id;

Line 377: p_return_status := hr_multi_message.get_return_status_disable;

373: -- Derive the API return status value based on whether
374: -- messages of any type exist in the Multiple Message List.
375: -- Also disable Multiple Message Detection.
376: --
377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,20);
379: --
380: exception
381: when hr_multi_message.error_message_exist then

Line 381: when hr_multi_message.error_message_exist then

377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,20);
379: --
380: exception
381: when hr_multi_message.error_message_exist then
382: --
383: -- Catch the Multiple Message List exception which
384: -- indicates API processing has been aborted because
385: -- at least one message exists in the list.

Line 394: p_return_status := hr_multi_message.get_return_status_disable;

390: --
391: p_offer_id := l_offer_id;
392: p_object_version_number := l_object_version_number;
393: p_offer_version := null;
394: p_return_status := hr_multi_message.get_return_status_disable;
395: hr_utility.set_location(' Leaving:' || l_proc, 30);
396: when others then
397: --
398: -- When Multiple Message Detection is enabled catch

Line 405: if hr_multi_message.unexpected_error_add(l_proc) then

401: -- Multiple Message List. Otherwise re-raise the
402: -- error.
403: --
404: rollback to update_offer_swi;
405: if hr_multi_message.unexpected_error_add(l_proc) then
406: hr_utility.set_location(' Leaving:' || l_proc,40);
407: raise;
408: end if;
409: --

Line 415: p_return_status := hr_multi_message.get_return_status_disable;

411: --
412: p_offer_id := l_offer_id;
413: p_object_version_number := l_object_version_number;
414: p_offer_version := null;
415: p_return_status := hr_multi_message.get_return_status_disable;
416: hr_utility.set_location(' Leaving:' || l_proc,50);
417: end update_offer;
418: -- ----------------------------------------------------------------------------
419: -- |-----------------------------< delete_offer >-----------------------------|

Line 445: hr_multi_message.enable_message_list;

441: savepoint delete_offer_swi;
442: --
443: -- Initialise Multiple Message Detection
444: --
445: hr_multi_message.enable_message_list;
446: --
447: -- Remember IN OUT parameter IN values
448: --
449: --

Line 479: p_return_status := hr_multi_message.get_return_status_disable;

475: -- Derive the API return status value based on whether
476: -- messages of any type exist in the Multiple Message List.
477: -- Also disable Multiple Message Detection.
478: --
479: p_return_status := hr_multi_message.get_return_status_disable;
480: hr_utility.set_location(' Leaving:' || l_proc,20);
481: --
482: exception
483: when hr_multi_message.error_message_exist then

Line 483: when hr_multi_message.error_message_exist then

479: p_return_status := hr_multi_message.get_return_status_disable;
480: hr_utility.set_location(' Leaving:' || l_proc,20);
481: --
482: exception
483: when hr_multi_message.error_message_exist then
484: --
485: -- Catch the Multiple Message List exception which
486: -- indicates API processing has been aborted because
487: -- at least one message exists in the list.

Line 493: p_return_status := hr_multi_message.get_return_status_disable;

489: rollback to delete_offer_swi;
490: --
491: -- Reset IN OUT parameters and set OUT parameters
492: --
493: p_return_status := hr_multi_message.get_return_status_disable;
494: hr_utility.set_location(' Leaving:' || l_proc, 30);
495: when others then
496: --
497: -- When Multiple Message Detection is enabled catch

Line 504: if hr_multi_message.unexpected_error_add(l_proc) then

500: -- Multiple Message List. Otherwise re-raise the
501: -- error.
502: --
503: rollback to delete_offer_swi;
504: if hr_multi_message.unexpected_error_add(l_proc) then
505: hr_utility.set_location(' Leaving:' || l_proc,40);
506: raise;
507: end if;
508: --

Line 511: p_return_status := hr_multi_message.get_return_status_disable;

507: end if;
508: --
509: -- Reset IN OUT and set OUT parameters
510: --
511: p_return_status := hr_multi_message.get_return_status_disable;
512: hr_utility.set_location(' Leaving:' || l_proc,50);
513: end delete_offer;
514: -- ----------------------------------------------------------------------------
515: -- |------------------------------< close_offer >-----------------------------|

Line 546: hr_multi_message.enable_message_list;

542: savepoint close_offer_swi;
543: --
544: -- Initialise Multiple Message Detection
545: --
546: hr_multi_message.enable_message_list;
547: --
548: -- Remember IN OUT parameter IN values
549: --
550: --

Line 585: p_return_status := hr_multi_message.get_return_status_disable;

581: -- Derive the API return status value based on whether
582: -- messages of any type exist in the Multiple Message List.
583: -- Also disable Multiple Message Detection.
584: --
585: p_return_status := hr_multi_message.get_return_status_disable;
586: hr_utility.set_location(' Leaving:' || l_proc,20);
587: --
588: exception
589: when hr_multi_message.error_message_exist then

Line 589: when hr_multi_message.error_message_exist then

585: p_return_status := hr_multi_message.get_return_status_disable;
586: hr_utility.set_location(' Leaving:' || l_proc,20);
587: --
588: exception
589: when hr_multi_message.error_message_exist then
590: --
591: -- Catch the Multiple Message List exception which
592: -- indicates API processing has been aborted because
593: -- at least one message exists in the list.

Line 599: p_return_status := hr_multi_message.get_return_status_disable;

595: rollback to close_offer_swi;
596: --
597: -- Reset IN OUT parameters and set OUT parameters
598: --
599: p_return_status := hr_multi_message.get_return_status_disable;
600: hr_utility.set_location(' Leaving:' || l_proc, 30);
601: when others then
602: --
603: -- When Multiple Message Detection is enabled catch

Line 610: if hr_multi_message.unexpected_error_add(l_proc) then

606: -- Multiple Message List. Otherwise re-raise the
607: -- error.
608: --
609: rollback to close_offer_swi;
610: if hr_multi_message.unexpected_error_add(l_proc) then
611: hr_utility.set_location(' Leaving:' || l_proc,40);
612: raise;
613: end if;
614: --

Line 617: p_return_status := hr_multi_message.get_return_status_disable;

613: end if;
614: --
615: -- Reset IN OUT and set OUT parameters
616: --
617: p_return_status := hr_multi_message.get_return_status_disable;
618: hr_utility.set_location(' Leaving:' || l_proc,50);
619: end close_offer;
620: -- ----------------------------------------------------------------------------
621: -- |------------------------------< hold_offer >------------------------------|

Line 652: hr_multi_message.enable_message_list;

648: savepoint hold_offer_swi;
649: --
650: -- Initialise Multiple Message Detection
651: --
652: hr_multi_message.enable_message_list;
653: --
654: -- Remember IN OUT parameter IN values
655: --
656: l_object_version_number := p_object_version_number;

Line 691: p_return_status := hr_multi_message.get_return_status_disable;

687: -- Derive the API return status value based on whether
688: -- messages of any type exist in the Multiple Message List.
689: -- Also disable Multiple Message Detection.
690: --
691: p_return_status := hr_multi_message.get_return_status_disable;
692: hr_utility.set_location(' Leaving:' || l_proc,20);
693: --
694: exception
695: when hr_multi_message.error_message_exist then

Line 695: when hr_multi_message.error_message_exist then

691: p_return_status := hr_multi_message.get_return_status_disable;
692: hr_utility.set_location(' Leaving:' || l_proc,20);
693: --
694: exception
695: when hr_multi_message.error_message_exist then
696: --
697: -- Catch the Multiple Message List exception which
698: -- indicates API processing has been aborted because
699: -- at least one message exists in the list.

Line 706: p_return_status := hr_multi_message.get_return_status_disable;

702: --
703: -- Reset IN OUT parameters and set OUT parameters
704: --
705: p_object_version_number := l_object_version_number;
706: p_return_status := hr_multi_message.get_return_status_disable;
707: hr_utility.set_location(' Leaving:' || l_proc, 30);
708: when others then
709: --
710: -- When Multiple Message Detection is enabled catch

Line 717: if hr_multi_message.unexpected_error_add(l_proc) then

713: -- Multiple Message List. Otherwise re-raise the
714: -- error.
715: --
716: rollback to hold_offer_swi;
717: if hr_multi_message.unexpected_error_add(l_proc) then
718: hr_utility.set_location(' Leaving:' || l_proc,40);
719: raise;
720: end if;
721: --

Line 725: p_return_status := hr_multi_message.get_return_status_disable;

721: --
722: -- Reset IN OUT and set OUT parameters
723: --
724: p_object_version_number := l_object_version_number;
725: p_return_status := hr_multi_message.get_return_status_disable;
726: hr_utility.set_location(' Leaving:' || l_proc,50);
727: end hold_offer;
728: -- ----------------------------------------------------------------------------
729: -- |-----------------------------< release_offer >----------------------------|

Line 760: hr_multi_message.enable_message_list;

756: savepoint release_offer_swi;
757: --
758: -- Initialise Multiple Message Detection
759: --
760: hr_multi_message.enable_message_list;
761: --
762: -- Remember IN OUT parameter IN values
763: --
764: l_object_version_number := p_object_version_number;

Line 799: p_return_status := hr_multi_message.get_return_status_disable;

795: -- Derive the API return status value based on whether
796: -- messages of any type exist in the Multiple Message List.
797: -- Also disable Multiple Message Detection.
798: --
799: p_return_status := hr_multi_message.get_return_status_disable;
800: hr_utility.set_location(' Leaving:' || l_proc,20);
801: --
802: exception
803: when hr_multi_message.error_message_exist then

Line 803: when hr_multi_message.error_message_exist then

799: p_return_status := hr_multi_message.get_return_status_disable;
800: hr_utility.set_location(' Leaving:' || l_proc,20);
801: --
802: exception
803: when hr_multi_message.error_message_exist then
804: --
805: -- Catch the Multiple Message List exception which
806: -- indicates API processing has been aborted because
807: -- at least one message exists in the list.

Line 814: p_return_status := hr_multi_message.get_return_status_disable;

810: --
811: -- Reset IN OUT parameters and set OUT parameters
812: --
813: p_object_version_number := l_object_version_number;
814: p_return_status := hr_multi_message.get_return_status_disable;
815: hr_utility.set_location(' Leaving:' || l_proc, 30);
816: when others then
817: --
818: -- When Multiple Message Detection is enabled catch

Line 825: if hr_multi_message.unexpected_error_add(l_proc) then

821: -- Multiple Message List. Otherwise re-raise the
822: -- error.
823: --
824: rollback to release_offer_swi;
825: if hr_multi_message.unexpected_error_add(l_proc) then
826: hr_utility.set_location(' Leaving:' || l_proc,40);
827: raise;
828: end if;
829: --

Line 833: p_return_status := hr_multi_message.get_return_status_disable;

829: --
830: -- Reset IN OUT and set OUT parameters
831: --
832: p_object_version_number := l_object_version_number;
833: p_return_status := hr_multi_message.get_return_status_disable;
834: hr_utility.set_location(' Leaving:' || l_proc,50);
835: end release_offer;
836: -- ----------------------------------------------------------------------------
837: -- |------------------------< create_offer_assignment >-----------------------|

Line 978: hr_multi_message.enable_message_list;

974: savepoint create_offer_assignment_swi;
975: --
976: -- Initialise Multiple Message Detection
977: --
978: hr_multi_message.enable_message_list;
979: --
980: -- Remember IN OUT parameter IN values
981: --
982: l_assignment_number := p_assignment_number;

Line 1126: hr_multi_message.add

1122: -- messages and add them to Multiple Message List
1123: --
1124: if l_other_manager_warning then
1125: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1126: hr_multi_message.add
1127: (p_message_type => hr_multi_message.g_warning_msg
1128: );
1129: end if;
1130: if l_hourly_salaried_warning then

Line 1127: (p_message_type => hr_multi_message.g_warning_msg

1123: --
1124: if l_other_manager_warning then
1125: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1126: hr_multi_message.add
1127: (p_message_type => hr_multi_message.g_warning_msg
1128: );
1129: end if;
1130: if l_hourly_salaried_warning then
1131: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');

Line 1132: hr_multi_message.add

1128: );
1129: end if;
1130: if l_hourly_salaried_warning then
1131: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');
1132: hr_multi_message.add
1133: (p_message_type => hr_multi_message.g_warning_msg
1134: );
1135: end if;
1136: --

Line 1133: (p_message_type => hr_multi_message.g_warning_msg

1129: end if;
1130: if l_hourly_salaried_warning then
1131: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');
1132: hr_multi_message.add
1133: (p_message_type => hr_multi_message.g_warning_msg
1134: );
1135: end if;
1136: --
1137: -- Convert API non-warning boolean parameter values

Line 1144: p_return_status := hr_multi_message.get_return_status_disable;

1140: -- Derive the API return status value based on whether
1141: -- messages of any type exist in the Multiple Message List.
1142: -- Also disable Multiple Message Detection.
1143: --
1144: p_return_status := hr_multi_message.get_return_status_disable;
1145: hr_utility.set_location(' Leaving:' || l_proc,20);
1146: --
1147: exception
1148: when hr_multi_message.error_message_exist then

Line 1148: when hr_multi_message.error_message_exist then

1144: p_return_status := hr_multi_message.get_return_status_disable;
1145: hr_utility.set_location(' Leaving:' || l_proc,20);
1146: --
1147: exception
1148: when hr_multi_message.error_message_exist then
1149: --
1150: -- Catch the Multiple Message List exception which
1151: -- indicates API processing has been aborted because
1152: -- at least one message exists in the list.

Line 1166: p_return_status := hr_multi_message.get_return_status_disable;

1162: p_assignment_number := l_assignment_number;
1163: p_comment_id := null;
1164: p_object_version_number := null;
1165: --
1166: p_return_status := hr_multi_message.get_return_status_disable;
1167: hr_utility.set_location(' Leaving:' || l_proc, 30);
1168: when others then
1169: --
1170: -- When Multiple Message Detection is enabled catch

Line 1177: if hr_multi_message.unexpected_error_add(l_proc) then

1173: -- Multiple Message List. Otherwise re-raise the
1174: -- error.
1175: --
1176: rollback to create_offer_assignment_swi;
1177: if hr_multi_message.unexpected_error_add(l_proc) then
1178: hr_utility.set_location(' Leaving:' || l_proc,40);
1179: raise;
1180: end if;
1181: --

Line 1192: p_return_status := hr_multi_message.get_return_status_disable;

1188: p_assignment_number := l_assignment_number;
1189: p_comment_id := null;
1190: p_object_version_number := null;
1191: --
1192: p_return_status := hr_multi_message.get_return_status_disable;
1193: hr_utility.set_location(' Leaving:' || l_proc,50);
1194: end create_offer_assignment;
1195: -- ----------------------------------------------------------------------------
1196: -- |------------------------< update_offer_assignment >-----------------------|

Line 1344: hr_multi_message.enable_message_list;

1340: savepoint update_offer_assignment_swi;
1341: --
1342: -- Initialise Multiple Message Detection
1343: --
1344: hr_multi_message.enable_message_list;
1345: --
1346: -- Remember IN OUT parameter IN values
1347: --
1348: l_assignment_id := p_assignment_id;

Line 1496: hr_multi_message.add

1492: -- messages and add them to Multiple Message List
1493: --
1494: if l_other_manager_warning then
1495: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1496: hr_multi_message.add
1497: (p_message_type => hr_multi_message.g_warning_msg
1498: );
1499: end if;
1500: if l_hourly_salaried_warning then

Line 1497: (p_message_type => hr_multi_message.g_warning_msg

1493: --
1494: if l_other_manager_warning then
1495: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1496: hr_multi_message.add
1497: (p_message_type => hr_multi_message.g_warning_msg
1498: );
1499: end if;
1500: if l_hourly_salaried_warning then
1501: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');

Line 1502: hr_multi_message.add

1498: );
1499: end if;
1500: if l_hourly_salaried_warning then
1501: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');
1502: hr_multi_message.add
1503: (p_message_type => hr_multi_message.g_warning_msg
1504: );
1505: end if;
1506: if l_no_managers_warning then

Line 1503: (p_message_type => hr_multi_message.g_warning_msg

1499: end if;
1500: if l_hourly_salaried_warning then
1501: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');
1502: hr_multi_message.add
1503: (p_message_type => hr_multi_message.g_warning_msg
1504: );
1505: end if;
1506: if l_no_managers_warning then
1507: fnd_message.set_name('PER', 'HR_289214_NO_MANAGERS');

Line 1508: hr_multi_message.add

1504: );
1505: end if;
1506: if l_no_managers_warning then
1507: fnd_message.set_name('PER', 'HR_289214_NO_MANAGERS');
1508: hr_multi_message.add
1509: (p_message_type => hr_multi_message.g_warning_msg
1510: );
1511: end if;
1512: if l_org_now_no_manager_warning then

Line 1509: (p_message_type => hr_multi_message.g_warning_msg

1505: end if;
1506: if l_no_managers_warning then
1507: fnd_message.set_name('PER', 'HR_289214_NO_MANAGERS');
1508: hr_multi_message.add
1509: (p_message_type => hr_multi_message.g_warning_msg
1510: );
1511: end if;
1512: if l_org_now_no_manager_warning then
1513: fnd_message.set_name('PER', 'HR_7429_ASG_INV_MANAGER_FLAG');

Line 1514: hr_multi_message.add

1510: );
1511: end if;
1512: if l_org_now_no_manager_warning then
1513: fnd_message.set_name('PER', 'HR_7429_ASG_INV_MANAGER_FLAG');
1514: hr_multi_message.add
1515: (p_message_type => hr_multi_message.g_warning_msg
1516: );
1517: end if;
1518: --

Line 1515: (p_message_type => hr_multi_message.g_warning_msg

1511: end if;
1512: if l_org_now_no_manager_warning then
1513: fnd_message.set_name('PER', 'HR_7429_ASG_INV_MANAGER_FLAG');
1514: hr_multi_message.add
1515: (p_message_type => hr_multi_message.g_warning_msg
1516: );
1517: end if;
1518: --
1519: -- Convert API non-warning boolean parameter values

Line 1530: p_return_status := hr_multi_message.get_return_status_disable;

1526: -- Derive the API return status value based on whether
1527: -- messages of any type exist in the Multiple Message List.
1528: -- Also disable Multiple Message Detection.
1529: --
1530: p_return_status := hr_multi_message.get_return_status_disable;
1531: hr_utility.set_location(' Leaving:' || l_proc,20);
1532: --
1533: exception
1534: when hr_multi_message.error_message_exist then

Line 1534: when hr_multi_message.error_message_exist then

1530: p_return_status := hr_multi_message.get_return_status_disable;
1531: hr_utility.set_location(' Leaving:' || l_proc,20);
1532: --
1533: exception
1534: when hr_multi_message.error_message_exist then
1535: --
1536: -- Catch the Multiple Message List exception which
1537: -- indicates API processing has been aborted because
1538: -- at least one message exists in the list.

Line 1554: p_return_status := hr_multi_message.get_return_status_disable;

1550: p_payroll_id_updated := null;
1551: p_validation_start_date := null;
1552: p_validation_end_date := null;
1553: p_offer_id := l_offer_id;
1554: p_return_status := hr_multi_message.get_return_status_disable;
1555: hr_utility.set_location(' Leaving:' || l_proc, 30);
1556: when others then
1557: --
1558: -- When Multiple Message Detection is enabled catch

Line 1565: if hr_multi_message.unexpected_error_add(l_proc) then

1561: -- Multiple Message List. Otherwise re-raise the
1562: -- error.
1563: --
1564: rollback to update_offer_assignment_swi;
1565: if hr_multi_message.unexpected_error_add(l_proc) then
1566: hr_utility.set_location(' Leaving:' || l_proc,40);
1567: raise;
1568: end if;
1569: --

Line 1582: p_return_status := hr_multi_message.get_return_status_disable;

1578: p_payroll_id_updated := null;
1579: p_validation_start_date := null;
1580: p_validation_end_date := null;
1581: p_offer_id := l_offer_id;
1582: p_return_status := hr_multi_message.get_return_status_disable;
1583: hr_utility.set_location(' Leaving:' || l_proc,50);
1584: end update_offer_assignment;
1585: -- ----------------------------------------------------------------------------
1586: -- |------------------------< delete_offer_assignment >-----------------------|

Line 1611: hr_multi_message.enable_message_list;

1607: savepoint delete_offer_assignment_swi;
1608: --
1609: -- Initialise Multiple Message Detection
1610: --
1611: hr_multi_message.enable_message_list;
1612: --
1613: -- Remember IN OUT parameter IN values
1614: --
1615: --

Line 1644: p_return_status := hr_multi_message.get_return_status_disable;

1640: -- Derive the API return status value based on whether
1641: -- messages of any type exist in the Multiple Message List.
1642: -- Also disable Multiple Message Detection.
1643: --
1644: p_return_status := hr_multi_message.get_return_status_disable;
1645: hr_utility.set_location(' Leaving:' || l_proc,20);
1646: --
1647: exception
1648: when hr_multi_message.error_message_exist then

Line 1648: when hr_multi_message.error_message_exist then

1644: p_return_status := hr_multi_message.get_return_status_disable;
1645: hr_utility.set_location(' Leaving:' || l_proc,20);
1646: --
1647: exception
1648: when hr_multi_message.error_message_exist then
1649: --
1650: -- Catch the Multiple Message List exception which
1651: -- indicates API processing has been aborted because
1652: -- at least one message exists in the list.

Line 1658: p_return_status := hr_multi_message.get_return_status_disable;

1654: rollback to delete_offer_assignment_swi;
1655: --
1656: -- Reset IN OUT parameters and set OUT parameters
1657: --
1658: p_return_status := hr_multi_message.get_return_status_disable;
1659: hr_utility.set_location(' Leaving:' || l_proc, 30);
1660: when others then
1661: --
1662: -- When Multiple Message Detection is enabled catch

Line 1669: if hr_multi_message.unexpected_error_add(l_proc) then

1665: -- Multiple Message List. Otherwise re-raise the
1666: -- error.
1667: --
1668: rollback to delete_offer_assignment_swi;
1669: if hr_multi_message.unexpected_error_add(l_proc) then
1670: hr_utility.set_location(' Leaving:' || l_proc,40);
1671: raise;
1672: end if;
1673: --

Line 1676: p_return_status := hr_multi_message.get_return_status_disable;

1672: end if;
1673: --
1674: -- Reset IN OUT and set OUT parameters
1675: --
1676: p_return_status := hr_multi_message.get_return_status_disable;
1677: hr_utility.set_location(' Leaving:' || l_proc,50);
1678: end delete_offer_assignment;
1679: -- ----------------------------------------------------------------------------
1680: -- |--------------------------< upload_offer_letter >-------------------------|

Line 1706: hr_multi_message.enable_message_list;

1702: savepoint upload_offer_letter_swi;
1703: --
1704: -- Initialise Multiple Message Detection
1705: --
1706: hr_multi_message.enable_message_list;
1707: --
1708: -- Remember IN OUT parameter IN values
1709: --
1710: --

Line 1740: p_return_status := hr_multi_message.get_return_status_disable;

1736: -- Derive the API return status value based on whether
1737: -- messages of any type exist in the Multiple Message List.
1738: -- Also disable Multiple Message Detection.
1739: --
1740: p_return_status := hr_multi_message.get_return_status_disable;
1741: hr_utility.set_location(' Leaving:' || l_proc,20);
1742: --
1743: exception
1744: when hr_multi_message.error_message_exist then

Line 1744: when hr_multi_message.error_message_exist then

1740: p_return_status := hr_multi_message.get_return_status_disable;
1741: hr_utility.set_location(' Leaving:' || l_proc,20);
1742: --
1743: exception
1744: when hr_multi_message.error_message_exist then
1745: --
1746: -- Catch the Multiple Message List exception which
1747: -- indicates API processing has been aborted because
1748: -- at least one message exists in the list.

Line 1754: p_return_status := hr_multi_message.get_return_status_disable;

1750: rollback to upload_offer_letter_swi;
1751: --
1752: -- Reset IN OUT parameters and set OUT parameters
1753: --
1754: p_return_status := hr_multi_message.get_return_status_disable;
1755: hr_utility.set_location(' Leaving:' || l_proc, 30);
1756: when others then
1757: --
1758: -- When Multiple Message Detection is enabled catch

Line 1765: if hr_multi_message.unexpected_error_add(l_proc) then

1761: -- Multiple Message List. Otherwise re-raise the
1762: -- error.
1763: --
1764: rollback to upload_offer_letter_swi;
1765: if hr_multi_message.unexpected_error_add(l_proc) then
1766: hr_utility.set_location(' Leaving:' || l_proc,40);
1767: raise;
1768: end if;
1769: --

Line 1772: p_return_status := hr_multi_message.get_return_status_disable;

1768: end if;
1769: --
1770: -- Reset IN OUT and set OUT parameters
1771: --
1772: p_return_status := hr_multi_message.get_return_status_disable;
1773: hr_utility.set_location(' Leaving:' || l_proc,50);
1774: end upload_offer_letter;
1775: -- ----------------------------------------------------------------------------
1776: -- |--------------------< is_run_benmgle_for_irec_reqd >----------------------|

Line 1950: hr_multi_message.enable_message_list;

1946: savepoint IS_RUN_BENMGLE_FOR_IREC_REQD;
1947: --
1948: -- Initialise Multiple Message Detection
1949: --
1950: hr_multi_message.enable_message_list;
1951: --
1952: -- Create an assignment record
1953: --
1954: l_offer_assignment_record.assignment_id := p_assignment_id;

Line 2140: p_return_status := hr_multi_message.get_return_status_disable;

2136: -- Derive the API return status value based on whether
2137: -- messages of any type exist in the Multiple Message List.
2138: -- Also disable Multiple Message Detection.
2139: --
2140: p_return_status := hr_multi_message.get_return_status_disable;
2141: hr_utility.set_location(' Leaving:' || l_proc,20);
2142: --
2143: exception
2144: when hr_multi_message.error_message_exist then

Line 2144: when hr_multi_message.error_message_exist then

2140: p_return_status := hr_multi_message.get_return_status_disable;
2141: hr_utility.set_location(' Leaving:' || l_proc,20);
2142: --
2143: exception
2144: when hr_multi_message.error_message_exist then
2145: --
2146: -- Catch the Multiple Message List exception which
2147: -- indicates API processing has been aborted because
2148: -- at least one message exists in the list.

Line 2152: p_return_status := hr_multi_message.get_return_status_disable;

2148: -- at least one message exists in the list.
2149: --
2150: rollback to IS_RUN_BENMGLE_FOR_IREC_REQD;
2151: --
2152: p_return_status := hr_multi_message.get_return_status_disable;
2153: p_is_run_reqd := 'N';
2154: --
2155: hr_utility.set_location(' Leaving:' || l_proc, 30);
2156: when others then

Line 2166: if hr_multi_message.unexpected_error_add(l_proc) then

2162: -- error.
2163: --
2164: rollback to IS_RUN_BENMGLE_FOR_IREC_REQD;
2165: --
2166: if hr_multi_message.unexpected_error_add(l_proc) then
2167: hr_utility.set_location(' Leaving:' || l_proc,40);
2168: raise;
2169: end if;
2170: --

Line 2171: p_return_status := hr_multi_message.get_return_status_disable;

2167: hr_utility.set_location(' Leaving:' || l_proc,40);
2168: raise;
2169: end if;
2170: --
2171: p_return_status := hr_multi_message.get_return_status_disable;
2172: p_is_run_reqd := 'N';
2173: --
2174: hr_utility.set_location(' Leaving:' || l_proc,50);
2175: --

Line 2308: hr_multi_message.enable_message_list;

2304: savepoint run_benmgle_for_irec;
2305: --
2306: -- Initialise Multiple Message Detection
2307: --
2308: hr_multi_message.enable_message_list;
2309: --
2310: -- Create an assignment record
2311: --
2312: l_offer_assignment_record.assignment_id := p_assignment_id;

Line 2439: p_return_status := hr_multi_message.get_return_status_disable;

2435: -- Derive the API return status value based on whether
2436: -- messages of any type exist in the Multiple Message List.
2437: -- Also disable Multiple Message Detection.
2438: --
2439: p_return_status := hr_multi_message.get_return_status_disable;
2440: hr_utility.set_location(' Leaving:' || l_proc,20);
2441: --
2442: exception
2443: when hr_multi_message.error_message_exist then

Line 2443: when hr_multi_message.error_message_exist then

2439: p_return_status := hr_multi_message.get_return_status_disable;
2440: hr_utility.set_location(' Leaving:' || l_proc,20);
2441: --
2442: exception
2443: when hr_multi_message.error_message_exist then
2444: --
2445: -- Catch the Multiple Message List exception which
2446: -- indicates API processing has been aborted because
2447: -- at least one message exists in the list.

Line 2451: p_return_status := hr_multi_message.get_return_status_disable;

2447: -- at least one message exists in the list.
2448: --
2449: rollback to run_benmgle_for_irec;
2450: --
2451: p_return_status := hr_multi_message.get_return_status_disable;
2452: hr_utility.set_location(' Leaving:' || l_proc, 30);
2453: when others then
2454: --
2455: -- When Multiple Message Detection is enabled catch

Line 2462: if hr_multi_message.unexpected_error_add(l_proc) then

2458: -- Multiple Message List. Otherwise re-raise the
2459: -- error.
2460: --
2461: rollback to run_benmgle_for_irec;
2462: if hr_multi_message.unexpected_error_add(l_proc) then
2463: hr_utility.set_location(' Leaving:' || l_proc,40);
2464: raise;
2465: end if;
2466: --

Line 2467: p_return_status := hr_multi_message.get_return_status_disable;

2463: hr_utility.set_location(' Leaving:' || l_proc,40);
2464: raise;
2465: end if;
2466: --
2467: p_return_status := hr_multi_message.get_return_status_disable;
2468: hr_utility.set_location(' Leaving:' || l_proc,50);
2469: --
2470: end run_benmgle_for_irec;
2471: --