DBA Data[Home] [Help]

APPS.PO_BUYER_WORKLOAD_SV dependencies on FND_API

Line 612: IF NOT FND_API.Compatible_API_Call ( l_api_version

608: l_progress VARCHAR2(3);
609: BEGIN
610: l_progress := '000';
611: -- Standard Call to check for call compatibility
612: IF NOT FND_API.Compatible_API_Call ( l_api_version
613: ,p_api_version
614: ,l_api_name
615: ,G_PKG_NAME)
616: THEN

Line 618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

614: ,l_api_name
615: ,G_PKG_NAME)
616: THEN
617: x_error_message := 'API version check raised exception';
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: END IF;
620:
621: --bug10315814 last_updated_by should be the user_id of the current user and not
622: --the employee_id of the new buyer

Line 625: x_return_status := FND_API.g_ret_sts_success;

621: --bug10315814 last_updated_by should be the user_id of the current user and not
622: --the employee_id of the new buyer
623:
624: l_progress := '005';
625: x_return_status := FND_API.g_ret_sts_success;
626: -- update all the records with the new buyer_id
627: forall i in p_req_line_id_tbl.FIRST..p_req_line_id_tbl.LAST
628: UPDATE po_requisition_lines_all
629: SET suggested_buyer_id = p_new_buyer_id,

Line 640: WHEN FND_API. G_EXC_UNEXPECTED_ERROR THEN

636: -- If the records were successfully updated, Commit the Transaction
637: commit;
638:
639: EXCEPTION
640: WHEN FND_API. G_EXC_UNEXPECTED_ERROR THEN
641: x_return_status := FND_API.g_ret_sts_unexp_error;
642: IF(x_error_message is NULL) then
643: x_error_message := 'Unexpected Error Occured at:' ||
644: l_progress || ' in req_reassign_action_bulk';

Line 641: x_return_status := FND_API.g_ret_sts_unexp_error;

637: commit;
638:
639: EXCEPTION
640: WHEN FND_API. G_EXC_UNEXPECTED_ERROR THEN
641: x_return_status := FND_API.g_ret_sts_unexp_error;
642: IF(x_error_message is NULL) then
643: x_error_message := 'Unexpected Error Occured at:' ||
644: l_progress || ' in req_reassign_action_bulk';
645: END IF;

Line 647: x_return_status := FND_API.g_ret_sts_unexp_error;

643: x_error_message := 'Unexpected Error Occured at:' ||
644: l_progress || ' in req_reassign_action_bulk';
645: END IF;
646: WHEN OTHERS THEN
647: x_return_status := FND_API.g_ret_sts_unexp_error;
648: IF(x_error_message is NULL) then
649: x_error_message := 'In Others, Exception at:' ||
650: l_progress || ' in req_reassign_action_bulk';
651: END IF;