DBA Data[Home] [Help]

APPS.IRC_OFFERS_SWI dependencies on HR_MULTI_MESSAGE

Line 81: hr_multi_message.enable_message_list;

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

Line 167: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 171: when hr_multi_message.error_message_exist then

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

Line 183: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 194: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 203: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 286: hr_multi_message.enable_message_list;

282: savepoint update_offer_swi;
283: --
284: -- Initialise Multiple Message Detection
285: --
286: hr_multi_message.enable_message_list;
287: --
288: -- Remember IN OUT parameter IN values
289: --
290: l_offer_id := p_offer_id;

Line 373: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 377: when hr_multi_message.error_message_exist then

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

Line 390: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 401: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 411: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 441: hr_multi_message.enable_message_list;

437: savepoint delete_offer_swi;
438: --
439: -- Initialise Multiple Message Detection
440: --
441: hr_multi_message.enable_message_list;
442: --
443: -- Remember IN OUT parameter IN values
444: --
445: --

Line 475: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 479: when hr_multi_message.error_message_exist then

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

Line 489: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 500: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 507: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 542: hr_multi_message.enable_message_list;

538: savepoint close_offer_swi;
539: --
540: -- Initialise Multiple Message Detection
541: --
542: hr_multi_message.enable_message_list;
543: --
544: -- Remember IN OUT parameter IN values
545: --
546: --

Line 581: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 585: when hr_multi_message.error_message_exist then

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

Line 595: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 606: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 613: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 648: hr_multi_message.enable_message_list;

644: savepoint hold_offer_swi;
645: --
646: -- Initialise Multiple Message Detection
647: --
648: hr_multi_message.enable_message_list;
649: --
650: -- Remember IN OUT parameter IN values
651: --
652: l_object_version_number := p_object_version_number;

Line 687: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 691: when hr_multi_message.error_message_exist then

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

Line 702: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 713: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 721: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 756: hr_multi_message.enable_message_list;

752: savepoint release_offer_swi;
753: --
754: -- Initialise Multiple Message Detection
755: --
756: hr_multi_message.enable_message_list;
757: --
758: -- Remember IN OUT parameter IN values
759: --
760: l_object_version_number := p_object_version_number;

Line 795: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 799: when hr_multi_message.error_message_exist then

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

Line 810: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 821: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 829: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 974: hr_multi_message.enable_message_list;

970: savepoint create_offer_assignment_swi;
971: --
972: -- Initialise Multiple Message Detection
973: --
974: hr_multi_message.enable_message_list;
975: --
976: -- Remember IN OUT parameter IN values
977: --
978: l_assignment_number := p_assignment_number;

Line 1122: hr_multi_message.add

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

Line 1123: (p_message_type => hr_multi_message.g_warning_msg

1119: --
1120: if l_other_manager_warning then
1121: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1122: hr_multi_message.add
1123: (p_message_type => hr_multi_message.g_warning_msg
1124: );
1125: end if;
1126: if l_hourly_salaried_warning then
1127: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');

Line 1128: hr_multi_message.add

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

Line 1129: (p_message_type => hr_multi_message.g_warning_msg

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

Line 1140: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1144: when hr_multi_message.error_message_exist then

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

Line 1162: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1173: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 1188: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1340: hr_multi_message.enable_message_list;

1336: savepoint update_offer_assignment_swi;
1337: --
1338: -- Initialise Multiple Message Detection
1339: --
1340: hr_multi_message.enable_message_list;
1341: --
1342: -- Remember IN OUT parameter IN values
1343: --
1344: l_assignment_id := p_assignment_id;

Line 1492: hr_multi_message.add

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

Line 1493: (p_message_type => hr_multi_message.g_warning_msg

1489: --
1490: if l_other_manager_warning then
1491: fnd_message.set_name('PER', 'HR_289215_DUPLICATE_MANAGERS');
1492: hr_multi_message.add
1493: (p_message_type => hr_multi_message.g_warning_msg
1494: );
1495: end if;
1496: if l_hourly_salaried_warning then
1497: fnd_message.set_name('PER', 'HR_289648_CWK_HR_CODE_NOT_NULL');

Line 1498: hr_multi_message.add

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

Line 1499: (p_message_type => hr_multi_message.g_warning_msg

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

Line 1504: hr_multi_message.add

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

Line 1505: (p_message_type => hr_multi_message.g_warning_msg

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

Line 1510: hr_multi_message.add

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

Line 1511: (p_message_type => hr_multi_message.g_warning_msg

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

Line 1526: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1530: when hr_multi_message.error_message_exist then

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

Line 1550: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1561: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 1578: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1607: hr_multi_message.enable_message_list;

1603: savepoint delete_offer_assignment_swi;
1604: --
1605: -- Initialise Multiple Message Detection
1606: --
1607: hr_multi_message.enable_message_list;
1608: --
1609: -- Remember IN OUT parameter IN values
1610: --
1611: --

Line 1640: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1644: when hr_multi_message.error_message_exist then

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

Line 1654: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1665: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 1672: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1702: hr_multi_message.enable_message_list;

1698: savepoint upload_offer_letter_swi;
1699: --
1700: -- Initialise Multiple Message Detection
1701: --
1702: hr_multi_message.enable_message_list;
1703: --
1704: -- Remember IN OUT parameter IN values
1705: --
1706: --

Line 1736: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1740: when hr_multi_message.error_message_exist then

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

Line 1750: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1761: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 1768: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1946: hr_multi_message.enable_message_list;

1942: savepoint IS_RUN_BENMGLE_FOR_IREC_REQD;
1943: --
1944: -- Initialise Multiple Message Detection
1945: --
1946: hr_multi_message.enable_message_list;
1947: --
1948: -- Create an assignment record
1949: --
1950: l_offer_assignment_record.assignment_id := p_assignment_id;

Line 2136: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 2140: when hr_multi_message.error_message_exist then

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

Line 2148: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 2162: if hr_multi_message.unexpected_error_add(l_proc) then

2158: -- error.
2159: --
2160: rollback to IS_RUN_BENMGLE_FOR_IREC_REQD;
2161: --
2162: if hr_multi_message.unexpected_error_add(l_proc) then
2163: hr_utility.set_location(' Leaving:' || l_proc,40);
2164: raise;
2165: end if;
2166: --

Line 2167: p_return_status := hr_multi_message.get_return_status_disable;

2163: hr_utility.set_location(' Leaving:' || l_proc,40);
2164: raise;
2165: end if;
2166: --
2167: p_return_status := hr_multi_message.get_return_status_disable;
2168: p_is_run_reqd := 'N';
2169: --
2170: hr_utility.set_location(' Leaving:' || l_proc,50);
2171: --

Line 2304: hr_multi_message.enable_message_list;

2300: savepoint run_benmgle_for_irec;
2301: --
2302: -- Initialise Multiple Message Detection
2303: --
2304: hr_multi_message.enable_message_list;
2305: --
2306: -- Create an assignment record
2307: --
2308: l_offer_assignment_record.assignment_id := p_assignment_id;

Line 2435: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 2439: when hr_multi_message.error_message_exist then

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

Line 2447: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 2458: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 2463: p_return_status := hr_multi_message.get_return_status_disable;

2459: hr_utility.set_location(' Leaving:' || l_proc,40);
2460: raise;
2461: end if;
2462: --
2463: p_return_status := hr_multi_message.get_return_status_disable;
2464: hr_utility.set_location(' Leaving:' || l_proc,50);
2465: --
2466: end run_benmgle_for_irec;
2467: --