487: /*End of modifications for Bug # 6144354 */
488:
489: SELECT document_set_id
490: INTO l_report_set_id
491: FROM wsh_picking_batches
492: WHERE NAME = l_request_number;
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN
495: x_return_status := fnd_api.g_ret_sts_error;
601: --AND organization_id = l_organization_id; Bug 8829363
602:
603: SELECT document_set_id
604: INTO l_report_set_id
605: FROM wsh_picking_batches
606: WHERE NAME = l_request_number;
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN
609: x_return_status := fnd_api.g_ret_sts_error;