703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
707: hr_multi_message.enable_message_list;
708:
709: hr_utility.set_location('Entering: Set_vehicle_mileage_claim',5);
710:
711: l_count:=l_count+1;
983: END IF;
984: END LOOP;
985: Commit;
986: EXCEPTION
987: WHEN hr_multi_message.error_message_exist THEN
988: --
989: -- Catch the Multiple Message List exception which
990: -- indicates API processing has been aborted because
991: -- at least one message exists in the list.
991: -- at least one message exists in the list.
992: --
993: --
994: -- Reset IN OUT parameters and set OUT parameters
995: x_return_status := hr_multi_message.get_return_status_disable;
996:
997: hr_utility.set_location(' Leaving:' ,40);
998: WHEN others then
999: --
1002: -- exceptions. Adding appropriate details to the
1003: -- Multiple Message List. Otherwise re-raise the
1004: -- error.
1005: --
1006: IF hr_multi_message.unexpected_error_add('l_proc') then
1007: --raise;
1008: x_return_status := hr_multi_message.get_return_status_disable;
1009: END IF;
1010: -- Reset IN OUT parameters and set OUT parameters
1004: -- error.
1005: --
1006: IF hr_multi_message.unexpected_error_add('l_proc') then
1007: --raise;
1008: x_return_status := hr_multi_message.get_return_status_disable;
1009: END IF;
1010: -- Reset IN OUT parameters and set OUT parameters
1011:
1012: x_return_status := hr_multi_message.get_return_status_disable;
1008: x_return_status := hr_multi_message.get_return_status_disable;
1009: END IF;
1010: -- Reset IN OUT parameters and set OUT parameters
1011:
1012: x_return_status := hr_multi_message.get_return_status_disable;
1013: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1014:
1015: /* WHEN hr_utility.hr_error THEN
1016: hr_utility.raise_error;