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: l_progress := '005';
622: x_return_status := FND_API.g_ret_sts_success;

Line 622: x_return_status := FND_API.g_ret_sts_success;

618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: END IF;
620:
621: l_progress := '005';
622: x_return_status := FND_API.g_ret_sts_success;
623: -- update all the records with the new buyer_id
624: forall i in p_req_line_id_tbl.FIRST..p_req_line_id_tbl.LAST
625: UPDATE po_requisition_lines_all
626: SET suggested_buyer_id = p_new_buyer_id,

Line 637: WHEN FND_API. G_EXC_UNEXPECTED_ERROR THEN

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

Line 638: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 644: x_return_status := FND_API.g_ret_sts_unexp_error;

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